Posted by gelangov on 01/29/07 15:04

I have this problem occuring intermittently:



When I try to add a package to the project, and click on the Package
path button. I get a oledb error x080004005 (client unable to
establish connection)...


After I click ok, and click on the Package path again 2 or 3 times,
the error goes away and I get the list of packages displayed. Some
time I get an empty list box.

Similar to this happens when I execute a package also. When I execute
it 2nd or 3 rd time it works fine. The error happens only when I am
trying to connect to the server\database. Once it is in the database
I do not get any error message.



This is what I have:


I have sql 2005 installed.

Microsoft SQL Server Management
Studio
9.00.1399.00

Microsoft Analysis Services Client
Tools
2005.090.1399.00

Microsoft Data Access Components
(MDAC)
2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)


Thank you in advance!!!

[Back to original message]