Forum Stats

  • 3,784,354 Users
  • 2,254,928 Discussions
  • 7,880,790 Comments

Discussions

Need a 32-bit ODBC Data Source

user13123110
user13123110 Member Posts: 2
edited Aug 1, 2018 1:10PM in ODBC

I've recently moved from Windows 7 (64-bit) & Microsoft Office 15 (64-bit) to Windows 10 (64-bit) & Microsoft Office 16 (32-bit).  I previously had a 64-bit ODBC DSN that worked for both SQL Developer and MS Access, as all platforms/applications were 64-bit.  I now have a 64-bit ODBC DSN that works fine for SQL Developer but not for MS Access any longer as that is 32-bit.  I try to create an ODBC DSN under ODBC Data Source Administrator (32-bit) and after selecting the Microsoft ODBD for Oracle, I get the following error.  How can I get the 32-bit data source added that I need for MS Access 32-bit while not messing up the 64-bit data source that I need for SQL Developer?  With any luck this is a quick fix...?

pastedImage_0.png

Answers

  • Sdhamoth-Oracle
    Sdhamoth-Oracle Member Posts: 184 Employee
    edited Aug 1, 2018 6:59AM

    You've to get the Oracle Instant Client 32bit and make sure oci.dll & ociw32.dll are in environment variable %PATH%, to make the 32bit DSN work.

    But Microsoft ODBC driver for Oracle is based on older client library(OCI7). We would recommend you to use Oracle Instant Client ODBC 32bit for 32bit ODBC DSN.

    You can find the installation instruction in the following page:

    ODBC Instant Client ODBC Release Notes

  • user13123110
    user13123110 Member Posts: 2
    edited Aug 1, 2018 1:10PM

    Success!  This was way more complicated than it should have been...downloading two different packages, unzipping them into the same directory, updating the PATH variable, creating a new TNS_ADMIN variable, creating the TNSNAMES.ORA file, and lastly creating the new System DSN and testing it successfully.  I do appreciate your assistance!

    pastedImage_0.png

This discussion has been closed.