1 Reply Latest reply on Feb 3, 2019 8:40 AM by Gaz in Oz

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

    3875335
    3875335 Jan 25, 2019 10:14 AM

      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

        • 1. Re: Instant client: Cannot connect through ODBC - ORASPAWN.DLL missing
          Gaz in Oz
          Gaz in Oz Feb 3, 2019 8:40 AM (in response to 3875335)

          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 Studio

           

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

          Download the File           [Released August 6, 2018]
          DownloadODTwithODAC122011.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