 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Other SQL Server Topics / January 2007intermittent OLE DB error
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!!! > 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 [quoted text clipped - 4 lines] > trying to connect to the server\database. Once it is in the database > I do not get any error message. I have no idea what this may be. However, I noted one thing: > I have sql 2005 installed. > [quoted text clipped - 5 lines] > Tools > 2005.090.1399.00 This is the RTM version of SQL 2005. There is an SP1 out. There is also an SP2 in progress, currently a preview of SP2 is available. I would recommend that you download an install SP1, and that you keep an eye open for the release of SP2. No promises that it will resolve your problem, though.  SignatureErland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx Thank you, Erland...I will try that! > (gelan...@hotmail.com) writes: > > After I click ok, and click on the Package path again 2 or 3 times, [quoted text clipped - 24 lines] > Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books... > Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.