Connection timeout

We recently moved our SQL Server to a faster machine. Everything is working great except every once in a while we get a connection timeout to the sql server. Everything else seems to be performing better but that initial connection is taking longer.

I realize this could be caused by a great deal of things, but if anybody has any suggestions I would appriciate it.

Thanks much.Leave an open connection for the next time the problem occurs. When it does, run exec sp_who2 and check the BlkBy column - if there is a value there, that is the id of the process (spid) that is blocking. Often you will have multiple blocking spids, and the key to that is to find the spid that is blocking at least one other spid but is not blocked - aka the culprit.

You can run DBCC INPUTBUFFER(culprit) to see what command it is running.

Happy hunting.

Connection Problems to Oracle Database

Hi,

I have a package connecting to oracle database ,this was developed on 32 bit Windows OS now i moved the same to 64 bit OS and it fails to connect to oracle database.

I have created system DSN and tested it was successfull.

In my package i am using ado.net connection object ,I am using ODBC data provider.I select the Data source in the drop down .provide user name and password and when i hit on test connection it fails with the following message

Test connection failed because of error in initilizing the provider error[08004]

[oracle][odbc][ora]ORA 12154 : TNS could not resolve the connect identifier specified

[Error]IM006[Microsoft][ODBC driver manager] drivers SQL setconnectattr failed

Any help on this will be appreciated

Note:- even though the OS is 64 bit i am using 32 bit ODBC as BI studio can only access 32 bit odbc

32-bit ODBC drivers won't run with 64-bit SSIS. You either need a 64-bit ODBC driver for Oracle (not sure if one exists) or run the 32-bit version of SSIS on the 64-bit box.|||Initially i had installed 64 bit oracle drivers and had created sytem dsn in 64 bit odbc but when i tried accesing the DSN(from drop down in connection object) i created in ado.net connection object i was not able to do so , as using the BI studio you can only access 32 bit odbc for which i had to install 32 bit oracle drivers after creating the dsn in 32 bit odbc i was able to access the DSN but when i did the test connection it failed.with above error message.