ADODB Provider 1

[enuss]

I am writing code that pulls from an external Oracle database. In order to use the code, I am trying to setup the connection to the oracle database using ADODB connection. Does anyone know what the provider would be for an oracle database?

The statement I am wanting to fill is:

dbConn.Open "Provider=?;Data Source=Metastorm;"

Thanks in advance,

Erich

 

[PHV]

Have a look here:

http://www.connectionstrings.com/

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[enuss]

That is going to help, I think. Thanks!