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