none
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

Answers

  • If your are running a 32 process on a 64 bit machine it will look in the 32 part of the registry.
    So you should use the Oracle 32 bit providers.

    HTH
    //Michael

    This posting is provided "AS IS" with no warranties.
    Wednesday, January 20, 2010 12:10 PM
  • 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:22 AM

All replies

  • If your are running a 32 process on a 64 bit machine it will look in the 32 part of the registry.
    So you should use the Oracle 32 bit providers.

    HTH
    //Michael

    This posting is provided "AS IS" with no warranties.
    Wednesday, January 20, 2010 12:10 PM
  • Yes, Michael is right. Make sure that you install Oracle client 32 bit version on this machine which also includes oledb provider 32 bit.

    Best regards

    Ryszard Gawron MSFT

    This posting is provided "AS IS" with no warranties
    Thursday, January 21, 2010 4:45 PM
  • 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:22 AM