Here is my code, w/o the username/password:

Dim cn As New ADODB.Connection
..
..
cn.Open "Provider=msdaora;Data Source=qse1.world;User ID=XX;Password=XX"

When I run it in Excel it pauses a few seconds on the cn.Open statement then
gives:

Run-time error '-2147467259(80004005)':
Automation error
Unspecified error

Any suggestions? I have tried just about every form of connection string
and get the same message. Thank you.

Brent

Also, are there any special libraries/references I need for this?


"Brent" wrote:

> Here is my code, w/o the username/password:
>
> Dim cn As New ADODB.Connection
> .
> .
> cn.Open "Provider=msdaora;Data Source=qse1.world;User ID=XX;Password=XX"
>
> When I run it in Excel it pauses a few seconds on the cn.Open statement then
> gives:
>
> Run-time error '-2147467259(80004005)':
> Automation error
> Unspecified error
>
> Any suggestions? I have tried just about every form of connection string
> and get the same message. Thank you.
>
> Brent
>

Sorry, went to:

cn.Open "Data Source=qse1;User ID=xx;Password=xx;"

and now it works.

"Brent" wrote:

> Also, are there any special libraries/references I need for this?
>
>
> "Brent" wrote:
>
> > Here is my code, w/o the username/password:
> >
> > Dim cn As New ADODB.Connection
> > .
> > .
> > cn.Open "Provider=msdaora;Data Source=qse1.world;User ID=XX;Password=XX"
> >
> > When I run it in Excel it pauses a few seconds on the cn.Open statement then
> > gives:
> >
> > Run-time error '-2147467259(80004005)':
> > Automation error
> > Unspecified error
> >
> > Any suggestions? I have tried just about every form of connection string
> > and get the same message. Thank you.
> >
> > Brent
> >