intermittent OLE DB error

[gelangov@hotmail.com]

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.0 0

Microsoft Data Access Components
(MDAC)
2000.085.1117.0 0 (xpsp_sp2_rtm.0 40803-2158)


Thank you in advance!!!

[Erland Sommarskog]

Re: intermittent OLE DB error

(gelangov@hotma il.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.0 0

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, esquel@sommarsk og.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

[gelangov@hotmail.com]

Re: intermittent OLE DB error

Thank you, Erland...I will try that!

On Jan 29, 6:07 pm, Erland Sommarskog <esq...@sommars kog.sewrote:

(gelan...@hotma il.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.0 0This 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...@sommarsk og.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.c om/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.c om/sql/prodinfo/previousversion s/books.mspx