Link to home
Start Free TrialLog in
Avatar of jdcollins21
jdcollins21

asked on

Can't Connect My Access Database to Oracle Backend with Oracle Provider

I downloaded and installed the oracle client software ass well as the data access components. But, I can only seem to connect to my Oracle DB with the Microsoft Provider and ODBC Driver.

As near as I can tell, my connection string is fine. If I use msdaora as the provider everything works flawlessly. But when I use OraOLEDB.Oracle.1 as my provider (or try to get an ODBC connection) I get the error message "Oraoledbpus10.dll: The specified module can not be found."  I can find it. It's right in the BIN folder of the home!

Here's the thing that gets me: I created a UDL and set up all the variables there. I tested the connection and it worked just fine. I try to run it from Access and *BOOM* I get the aforementioned error.

In Access, Im just using

Dim Conn and New ADODB.Connection

Conn.open "my connection string"

Here's my string (I replaced actual values with <value> below)

 Provider=OraOLEDB.Oracle.1;Password=<password>;User ID=<userid>;Data Source=<server>:<port>/<database name>
ASKER CERTIFIED SOLUTION
Avatar of PC_Rob
PC_Rob

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jdcollins21
jdcollins21

ASKER

I went to include my path and it was already there. I also had a user PATH variable pointing to a folder. I got rid of it and now everything's right as rain. Thank's PC_Rob...you're a gentleman and a scholar.
Avatar of rockiroads
Have you got a TNSNames entry setup? eg FRED, when u use MSDAORA u could try just using that instead of ODBC

    adoConn.Provider = "MSDAORA"
    adoConn.Open "FRED.WORLD", "userid", "pswd"