ADO connection string error??
 

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

ADO connection string error??
 

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

ADO connection string error??
 

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