Forum Stats

  • 3,836,791 Users
  • 2,262,192 Discussions


Instant client: Cannot connect through ODBC - ORASPAWN.DLL missing

3875335 Member Posts: 1
edited Feb 3, 2019 3:40AM in ODBC


I have a problem with Oracle instant client.

I installed instant client (  - just necessary binaries) and additional odbc libraries ( 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.





  • Gaz in Oz
    Gaz in Oz Member Posts: 3,785 Bronze Crown
    edited Feb 3, 2019 3:40AM

    You should probably be using compents fro the 32 bit ODAC library:

    32-bit Oracle Data Access Components (ODAC)
    with Oracle Developer Tools for Visual Studio

    ODAC 12.2c Release 1 and Oracle Developer Tools for Visual Studio (

    Download the File           [Released August 6, 2018] 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
    -Oracle Data Provider for .NET 4
    -Oracle Data Provider for .NET 2.0
    -Oracle Providers for ASP.NET 4
    -Oracle Providers for ASP.NET 2.0
    -Oracle Data Provider for .NET Oracle TimesTen In-Memory Database
    -Oracle Provider for OLE DB
    -Oracle Services for Microsoft Transaction Server
    -Oracle ODBC Driver
    -Oracle SQL*Plus
    -Oracle Instant Client