32 bit application not running on 64 bit OS RRS feed

  • Question

  •  We have a 32 bit application which we are trying to run on Windows Server 2003 64 bit machine. The service is not starting up with an error as

    "COM Error: -2146824582, Source: ADODB.Connection, Description: Provider cannot be found. It may not be properly installed., error message: Unknown error 0x800A0E7A"

    Below is the ConnectionString used:

    std::tstringstream ssConnectionStream;

    ssConnectionStream     << _T("Provider=OraOLEDB.Oracle;")

                                        << _T("User ID=") << this->GetUID() << _T(";")

                                        << _T("Password=") << this->GetPWD() << _T(";")

                                        << _T("Data Source=") << this->GetDbSource() << _T(";");

    We are having 64 bit Oracle Database server installed on 64 bit machine.

    Please help on above if anybody has solution for the above.

    Wednesday, January 20, 2010 11:00 AM

All replies


    Thanks for your support.
    We manage to resolve this issue by using Oracle 32-Bit client on the same server. 32-Bit OraOLEDB.Oracle 

    provider comes with the Oracle 32-Bit client. So following are the configuration on the server for this issue.

    Windows 64-Bit Server.
    Oracle 64-Bit Database.
    32-Bit Application.
    Oracle 32-Bit Client.

    Set the "TNS_ADMIN" in envionment variable for 64-Bit installation.

    Eg. TNS_ADMIN = <64-Bit Database Home>\Network\Admin

    Monday, January 25, 2010 4:21 AM