Answer Questions

• DD_Helmetman A couple of questions on Remote connection to SQL Server 2005 database

  I have a SQL Server 2005 database (called BDHSE) in a PC which i call PC1. I have a second PC (PC2) and both are within a network (a WLAN). What i want is to have access to BDHSE from an application in VB6 (APP1) running in PC2. All the INSERT, DELETE, UPDATE records process is done through APP1. APP1 ia currently running in PC1 and is to be installed on PC2. I have these questions: 1. What do i need to install in PC2 since all the INSERT, DELETE, and UPDATE is done using APP1 I guess i only have to install the Microsoft SQL Native Client (with all the prerequisites of course) but i am not sure. 2. In the APP1 made in VB6, do i have to change the connectionstring since i am accesing the database which physically is at PC1 a ...Show All

• Abhishek_SE Help with query - New to SQL

  Not sure how to quite ask this question. I know how to do what I want under MySQL but with MS SQL I'm mystified. The main issue is that the database I'm attempting to access is fairly large so my query times out also that I lack any real access to the server itself except via my workstation. What I'd like to do is try to map the structure of a table in the database so that I can see what fields the front end is current not utilizing. The basic setup is a webserver and access the database via PHP. I'm hoping that this is a simple thing to do but I haven't found a solution yet anywhere online. < php require ("connect.inc"); $db = @MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO RESPOND."); ms ...Show All

• acemuzzy Count Item function

  Hi, I need to count the number of rows in my Item table. The following statement gives me the number i.e. 200. Select Count(*) As Counter From Item Group By Id How can I number each individual row so that the row will have a number next to it i.e. Select Count(*) As Counter, [Count Statement] as Number of the Row From Item Group By Id Thanks You should actually do this on the client-side where it is easier and it will perform better. Simply return the rows in a sorted manner and then number them on the client side. I am not sure, I get the following error. Server: Msg 195, Level 15, State 10, Line 1 'Row_NUMBER' is not a recognized function name. Server: Msg 170, Level 15, State 1, Line 9 Line 9: Incorrec ...Show All

• ABOH Indirect Configuration with ConfigType 'Indirect SQL Server' fails

  Hi, I have a package that uses a Configuration of type SQL Server where the property values are held. This runs successfully using this direct configurations. When I use an Indirect configuration using an environment variable to point to this SQL Server configuration type the package won't even validate. The Indirect Configuration is: [EHC-SQLD-01.].[SSISConfigsDEV];[dbo].[SSIS Configurations DEV];pkgLRD CED Import; which follows the standard of : db connections, config table, filter This works by the way on my client but on the dev server the error is: Error: The connection "[EHC-SQLD-01].SSISConfigsDEV" is not found. This error is thrown by Connections collection when the specific connection element is not found. ...Show All

• Gaurav_Gaur Subsystems could not be loaded

  Hi, I'm running SQL Server Agent services and SQL Server Integration services under same Domain\User account and the same Domain\User account is also having sysadmin rights in sql server. And below is the SQLAgent.OUT file details which I'm getting while running the SSIS from SQL Agent job. [100] Microsoft SQLServerAgent version 9.00.1399.06 (x86 unicode retail build) : Process ID 4012 [101] SQL Server MachineNameXYZ version 9.00.1399 (0 connection limit) [102] SQL Server ODBC driver version 9.00.1399 [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is [310] 4 processor(s) and 3072 MB RAM detected [339] Local computer is MachineNameXYZ running Windows NT 5.2 (3790) Service Pack 1 [432] There are 11 subsystems ...Show All

• Michael Vainer Visual Studio.net Academic (2002) with Sql Server Express 2005?

  Can Visual Studio.net Academic (2002) be used with Sql Server Express 2005 There is nothing that would stop you from making connections to SQL 2005 but any built in tools, such as database designers will not work correctly. Mike ...Show All

• Arkady Frenkel SQL server 2005 table partition & Performance.

  Hi all, My question is regarding the SQL server 2005 table partitions. The scenario: ============= I have tables A & B with table A having 1 million records and table B with 2 million records. When I run a procedure which has few computations involving tables A & B, the time taken for the stored procedure to return the result set is 55 seconds. Now, I partition table A based on a column which is used in the join condition within the stored procedure and then try the same query. Still, it takes the same 55 seconds and I could not find any time differences even after going for partitioning and placing the partitions in different file groups. Clarifications needed: ...Show All

• forrestcupp SSMA for Sybase ASE

  SSMA for Sybase: When i am trying to connect to Sybase ASE 12.5.x in SSMA for Sybase.I am unable to connect to Syabse.I am getting this Error Message "Error collecting data. See the inner exception for details." Please help me in this issue or advise me what i can do thanks sanaku SSMA 1.1.618 has a known bug, which can appear when the Sybase server is 12.5.0.x. Seems it is exactly your problem.   I suggest using a newer SSMA build (1.1.679), where we have fixed this bug." Try contacting Microsoft support in this case. ...Show All

• salafa Passing the User ID and AD group as Parameter

  Hi... I have a requirement where I need to pass the Users Windows userID and the AD group through which he is associated to the database so that I can get appropiate data. Is there a way I can pass the Windows user ID and the AD group(through which he is authenticated in Reporting Serivces) through the Reporting Serivces as a parameter so that it can be used in the Reporting Query. Thanks, siaj test As Jens says, UserID is just available using the internal object. For the AD group you should consider writing a custom assembly that performs the operation according to your business rules to decide which is THE group among the ones the user may pertain. I've not checked how difficult it will be to write such code in .Net bu ...Show All

• Prasad Selladurai Converting String to Date in Report Expressions

  Hello, I am running a report in RS 2005 and as an expression I have something like that: =DateDiff( "YYYY" , NOW(), CDATE( "2001" )) Unfortunately, I am getting message: Conversion from string "2001" to type 'Date' is not valid. Is there a way to fix it Thanks! Greate advice! Thanks for your help! The CDATE function wants a valid date format passed to it and not just the year. It would work if you specified something like "1/1/2001" or "Jan 1, 2006". However, it appears all you're trying to do is find the difference between the current year and some specified year. If that's the case, I would suggest using the following expression instead: =Year(No ...Show All

• sharrock importing data from interbase

  Hi, I'm trying to write a integration services package with interbase involved in it. Set up a DataReaderSource with a totally basic sqlcommand: select * from BDR, connect to Interbase using ADO.NET. Unfortunately I'm getting an error : "Error at Data Task [DTS.Pipeline]: The "output column "TIME (50)""has a length that is not valid. The length must be between 0 and 4000." I got the same problem with six different columns. Each time a change the data type in the input or output proporties I get an Error : Invalid Data Type. Do Anybody have an Idea how to solve this kind of problem Is there a possibility to convert the data in the DataReaderSource I really got stuck and still looking for any solution ... I'll ...Show All

• Lars E.Nes Deploy report question

  HI there. I am new to this. I need to deploy a report to the web, however the Web Service Identity is not set up on my Reporting services configuration and I do not know how to set it up. WE are running SQL 2005 SP1. Does any one have any documentation or tips on this. THanks Have a look at this site, it may help... http://blogs.msdn.com/williaml/archive/2006/09/22/767255.aspx cheers, Andrew That did not work for me. When I go to the dabase Set up in the report server and click apply, I get an error message at the bottom on the Task Status Area that says . Assigning Reporting services rights to users. The reporting services rights were not applied properly. The user may still not have appro ...Show All

• ShrikantBijapurkar (SubReports) Is it possible to...

  Here's my dilema. Our organization has two db servers. One is Oracle and the other is SQL Server. Oracle contains our HR information on all employees and SQL Server contains information on various projects that we are undertaking. The HR system (Oracle) contains Employee ID's, Names, addresses, phone numbers, etc. SQL Server has information about the varous projects and Employee ID's of who is assigned to those projects. I have a report that has two data sources (one to each server) and two datasets (each populated from the two datasources). I would like to have a single table that displays the project and the name of the person who's assigned to that project. This would be achieved by linking the tables on similar information, which is th ...Show All

• Zooz Use a tabel from another SQL server in a view

  Hope this is the right place, I have SQL server x and y In server x I have som tables I would like to use in Views in Server Y (Server X and Y are on different servers both on same network) How can I do this Hi, You probably want the "Sql Server Databaser Engine" forum. What you're looking for is "Linked Server" which is way of creating an alias to a remote database inside you local database. It'll let you do what you want. There's a series of articals here - http://www.databasejournal.com/features/mssql/article.php/3085211 which should put you on the right track. Dave ...Show All

• Flecko1 LOOKUP: specifying parameters for the SQL Query

  guys i'm trying to use a Lookup in a dataflow that looksup stuff in the results of a query. Problem I have is that the query needs to take two parameters.. (Source and BaseCurrency in the code below) and i can't figure out how to supply the parameters.. Parameters can be supplied in other task types or transforms .. but can't see how to do it in the Lookup... PJ SELECT ForeignCurrency, RateFromFile AS YesterdaysRate FROM inputrates IR WHERE fileheaderid in ( SELECT top 1 MAX(ID) FROM FileInputAttempts FIA WHERE Source = ' ' AND FIA.BaseCurrency = ' ' AND status = 'SUCCESS' Group by CAST(FLOOR(CAST(LoadDate AS float))AS datetime) order by MAX(loaddate) DESC ) ...Show All