Within an Access 2007 .mdb, I need to establish a connection to an Oracle 10
table in order to update that table. I'm not able to establish that
connection. Here is the code below:

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim cmd As ADODB.Command

Set cn = New ADODB.Connection
Set cmd = New ADODB.Command
Set rs = New ADODB.Recordset

cn = "Provider='msdaora';Data Source='ACIIS';User
Id='ACIIS_ADMIN';Password='xxxxxxxx';"
cn.Open


Receive following error message:
Unrecoverable error
:Provider cannot be found. It may not be properly installed. [3706]

I get the same error message when I replace the connection string code to the Oracle driver:

cn.Provider = "Driver='OraOLEDB';Data Source='ACIIS';User
Id='ACIIS_ADMIN';Password='aciis8adm';"


Help
Pierre

You need to have the Oracle client software installed on your computer, and you need to do something like this:

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim cmd As ADODB.Command
Dim sCN As String

Set cn = New ADODB.Connection
Set cmd = New ADODB.Command
Set rs = New ADODB.Recordset

sCN = "Provider='msdaora';Data Source='ACIIS';User
Id='ACIIS_ADMIN';Password='xxxxxxxx';"

cn.Open sCN

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com