locked
64 bit Microsoft ODBC Driver for Oracle RRS feed

  • Question

  • Hello,

    Does Microsoft provide a 64 bit ODBC Driver for Oracle and where we can get it?

    But what I really need is to run .NET Application in 64 bit environment, can I run the app in 64 bit and use a  32 bit driver?\

    Thanks.

     

    Sunday, September 26, 2010 6:01 AM

Answers

  • To your second question, the answer is no. To run your Oracle in 64-bit will require a 64-bit data access library. You may want to consider using ODP.NET (the native .NET provider) instead of ODBC.

    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Marked as answer by liurong luo Friday, October 1, 2010 9:34 AM
    Tuesday, September 28, 2010 3:55 PM
  • Oracle ODBC Drivers are now supplied by Oracle. I recommend that you look into their developer tools (http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html), or Instant Client with the ODBC Supplement if you need to install the driver onto client machines (http://www.oracle.com/technetwork/topics/winx64soft-089540.html)

    Please be aware: The links provided above are simply for convenience and recommendations made as per information on Oracle's website. You should contact Oracle for further information.

    • Marked as answer by liurong luo Friday, October 1, 2010 9:30 AM
    Monday, September 27, 2010 6:59 PM

All replies

  • Oracle ODBC Drivers are now supplied by Oracle. I recommend that you look into their developer tools (http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html), or Instant Client with the ODBC Supplement if you need to install the driver onto client machines (http://www.oracle.com/technetwork/topics/winx64soft-089540.html)

    Please be aware: The links provided above are simply for convenience and recommendations made as per information on Oracle's website. You should contact Oracle for further information.

    • Marked as answer by liurong luo Friday, October 1, 2010 9:30 AM
    Monday, September 27, 2010 6:59 PM
  • To your second question, the answer is no. To run your Oracle in 64-bit will require a 64-bit data access library. You may want to consider using ODP.NET (the native .NET provider) instead of ODBC.

    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Marked as answer by liurong luo Friday, October 1, 2010 9:34 AM
    Tuesday, September 28, 2010 3:55 PM
  • Did you ever get resolution on this?  I'm trying to connect Windows 10 based Access (64 bit) to Oracle.  I used to use Oracle 11g to connect with my Windows 7 but I'm unable to find a solution for the Win 10.

    Thanks

    Tuesday, June 27, 2017 4:04 PM
  • Thursday, July 6, 2017 1:17 AM
  • I created the Microsoft ODBC drivers for Oracle this way,  

    1. Find the table in MS Access not in Oracle (make sure all the column names and table names are Upper Case)
    2. Right click > Export > ODBC Databases
    3. Click OK
    4. Click on the "Machine Data Source" tab
    5. Click the New button
    6. Click the radio button "User Data Sources"
    7. Click the "Next >" button
    8. Scroll down until you see the "Microsoft ODBC for Oracle" driver
    9. Select it and click the "Next >" button
    10. Add all the credentials and this will create driver and add it your Data Sources going forward
    Friday, October 6, 2017 7:25 PM
  • I used the Oracle 12c driver and it worked for 64 bit.
    Thursday, March 15, 2018 6:26 PM
  • Hi Do you also have the "Microsoft ODBC for oracle" available under System DSN in your 64bit ODBC? TIA
    Friday, July 19, 2019 2:53 PM