469,568 Members | 1,394 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,568 developers. It's quick & easy.

intermittent 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!!!

Jan 29 '07 #1
2 2422
(ge******@hotmail.com) writes:
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.
I have no idea what this may be. However, I noted one thing:
I have sql 2005 installed.

Microsoft SQL Server Management
Studio
9.00.1399.00

Microsoft Analysis Services Client
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.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jan 29 '07 #2
Thank you, Erland...I will try that!

On Jan 29, 6:07 pm, Erland Sommarskog <esq...@sommarskog.sewrote:
(gelan...@hotmail.com) writes:
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.I have no idea what this may be. However, I noted one thing:
I have sql 2005 installed.
Microsoft SQL Server Management
Studio
9.00.1399.00
Microsoft Analysis Services Client
Tools
2005.090.1399.00This 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.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

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
Jan 30 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by bloodhound | last post: by
8 posts views Thread by trinitypete | last post: by
3 posts views Thread by Lee Chapman | last post: by
reply views Thread by Shane C | last post: by
2 posts views Thread by =?Utf-8?B?RGFycmVs?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.