Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 390 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
InstantClient: SQORAS32.DLL could not be found
Hello,
I'm trying to configure the instant client driver to connect Oracle db from excel 32-bit, but when I try to configure the instant client from the odbc data source administrator, I receive the following error message:
"The setup routines for the Oracle in instantclient_12_2 ODBC Driver could not be loaded due to system error code 126: The specified module could not be found.
(C:\Oracle\instantclient_12_2\SQORAS32.DLL)"
I've installed the instant client basic and odbc packages, run the odbc_install.exe from windows cmd, and updated the environment variables afterwards to include C:\Oracle\instantclient_12_2 and TSD_ADMIN.
PC I'm trying this with is Windows 8.1 pro with excel 2016 32-bit.
I've also made sure that both microsoft KB3147071 and Visual C++ 2010 packages are installed, as I found some notes referring to them, but still the same error message persists.
Could you please help me with this issue?
Best Regards
Giacomo
Answers
-
Hi,
which version of VC++ 2010 redistributable package have you installed (32 bit or 64bit)?
Since you want to connect from 32bit version of Excel, you should have 32bit version of Oracle ODBC driver, VC++ 2010 redistributable package x86 in your environment.
Make sure you have the right combination.
Thanks & Regards,
Senthil
-
Hi Senthil,
thank you for your help,
actually both x86 and x64 VC++ 2010 redistributable packages were already installed on the machine, on version 10.0.40219 .
thanks®ards
Giacomo
-
Have you invoked the right version (32bit version) of ODBC Data source administrator to configure. For 32bit ODBC, you need to invoke C:\Windows\SysWOW64\obdcad32.exe.
-
Yes, double checked it, I'm using the 32-bit version of odbc data source administrator (the one found under C:\Windows\SysWOW64\odbcad32.exe), but still got the same message,
thank you
Giacomo
-
You say you have instantclient_12_2 and the 2010 redistributables. However (from the Instant Client download page) you need the 2013 redistributables with 12.2
-
Install Microsoft Visual Studio 2013 Redistributable package over 12.2 Oracle client/instant client homes.
It can be downloaded from the below location: