Serious problems to run SSIS packages from Sql Server 2012 64 bit platform against Oracle 10.2g database over ODBC.

  • WilburSmith

    SSCrazy

    Points: 2896

    Hello,

    (the same is attached in rtf doc if better)

    Any help would be appreciated, I've run out of time and ideas...next I will install 64 bit Oracle client and try to run the packages with Agent JOB

    ETL Server:

    Win 2008 R2 Enterprise 64 server SP1

    SqlServer 2012 / MS Visual Studio 2010 SP1

    (Both SSIS development and actual JOBs are run at the same server)

    Oracle 10.2 client 32 bit installed (NOTE: 64 bit client not yet installed the to avoid the possible effect in the 32 bit testing)

    (Source DB is Oracle 10.2g as well)

    • Cofiguring the ODBC alias goes OK (after an Oracle ODBC patch installation)

    • ODBC connection test OK

    • SSIS Package ADO Net connection over ODBC OK

    • Table/column metadata can be read OK

    • Data preview in ADO Net Source OK

    But

    When the package is executed in SSIS:

    ADO NET Source has failed to acquire the connection {0731A90B-50CC-4160-8C15-B2D69C17EF76} with the following error message: "ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application".

    When package is executed under Sql Agent ('32 bit runtime' checked):

    "ADO NET Source has failed to acquire the connection {0731A90B-50CC-4160-8C15-B2D69C17EF76} with the following error message: "ERROR [IM003] Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (Oracle in OraClient10g_home1, D:\oracle\product\10.2.0\client_1\BIN\SQORA32.DLL)."

    When package is executed under Sql Agent ('32 bit runtime' NOT checked, that is 64 bit runtime used):

    "The specified DSN contains an architecture mismatch between the Driver and Application"

    Note: no 64 bit Oracle client nor 64 bit ODBC alias created...still it seems to have been able to validate the connection??

    More:

    Why am I using ADO NEt Source / ODBC and not OleDB? Well, OleDB is not working

    "Cannot retrieve column code page information....."

    BUT OleDB works perfectly OK with another Oracle 10.2 instance...!??! What is the clue here...

  • Mahesh Hello

    Mr or Mrs. 500

    Points: 549

    Got stuck into same issue today.... any resolution?

    TITLE: Connection Manager
    ------------------------------

    Test connection failed because of an error in initializing provider. ERROR [IM003] Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (Oracle in OraHome112_32_home_1, C:\ORACLE\ora112_32_home\BIN\SQORA32.DLL).

    --------

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply