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
Instant client: Cannot connect through ODBC - ORASPAWN.DLL missing
Hello,
I have a problem with Oracle instant client.
I installed instant client (instantclient-basic-nt-12.2.0.1.0.zip - just necessary binaries) and additional odbc libraries (instantclient-odbc-nt-12.2.0.1.0-2.zip) to some custom folder.
OLE DB access works correctly but I have also some old app (32bit) which connects from ADO.NET through OLE DB to ODBC adapter and this does not work for me.
ODBC is installed and found but while debugging I found it is looking for some strange library I can't find in any of your package: ORASPAWN.DLL
It looks like it fails just after this dll is not found but I'm not absolutely sure about it.
Should this library be part of instant client when used through ODBC? What is the purpose of this library?
If it is really not needed, why is it asking for that library?
Please help, I'm stuck on this.
Regards,
Jan
Answers
-
You should probably be using compents fro the 32 bit ODAC library:
https://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html
32-bit Oracle Data Access Components (ODAC)
with Oracle Developer Tools for Visual StudioODAC 12.2c Release 1 and Oracle Developer Tools for Visual Studio (12.2.0.1.1)
Download the File [Released August 6, 2018] 
ODTwithODAC122011.zip 411 MB (431,571,252 bytes) ODAC Installation Instructions Important: If installing ODAC into an existing Oracle 12c home, review the "Common Install and Setup Issues" section of the ODAC installation instructions.
Download Includes- Oracle Developer Tools for Visual Studio 12.2.0.1.0 - Oracle Data Provider for .NET 4 12.2.0.1.0 - Oracle Data Provider for .NET 2.0 12.2.0.1.0 - Oracle Providers for ASP.NET 4 12.2.0.1.0 - Oracle Providers for ASP.NET 2.0 12.2.0.1.0 - Oracle Data Provider for .NET Oracle TimesTen In-Memory Database 12.2.0.1.0 - Oracle Provider for OLE DB 12.2.0.1.0 - Oracle Services for Microsoft Transaction Server 12.2.0.1.0 - Oracle ODBC Driver 12.2.0.1.0 - Oracle SQL*Plus 12.2.0.1.0 - Oracle Instant Client 12.2.0.1.0
