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>/<da tabase name>
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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"
adoConn.Provider = "MSDAORA"
adoConn.Open "FRED.WORLD", "userid", "pswd"
ASKER