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

Posted on 2007-07-24
Last Modified: 2013-12-25
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 "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>
Question by:jdcollins21
    LVL 9

    Accepted Solution


    Try adding the folder where that Oracle DLL lives to your Windows Path:

    Right Click My computer, Properties, Advanced Tab, Environment Variables button, Change your PATH statement to include the full path to your dll folder c:\oracle\bin or whatever yours is.



    Author Comment

    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're a gentleman and a scholar.
    LVL 65

    Expert Comment

    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"

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now