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

(gelangov@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, esquel@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

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

On Jan 29, 6:07 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (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