Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Need a 32-bit ODBC Data Source

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...?
Answers
-
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:
-
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!