Need a 32-bit ODBC Data Source

user13123110

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...?

Sdhamoth-Oracle

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

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!