Post reply

Problem while connecting to oracle through SQL server 2005 64 bit SSIS package

  • October 24, 2009 at 3:17 am

    #139703

    Hii All,

    i have developement server on which foll components are installed,

    Windows server 2003 std 64bit

    SQL server 2005 64bit client (don't have database engine installed)

    Oracle client10.2 64 bit

    i created service name 'uat' (find the tnsnames.ora file as attachment here)

    but when i test connection to oracle server using 'oracle provider for OLEDB' through SSIS package

    i get an error,

    "OraOLEDB.Oracle.1 provider is not registered on the local machine" (find the attachment)

    Kindly provide the soln.

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • October 24, 2009 at 5:28 pm

    #1070417

    Hi,

    The Visual Studio is a 32 bit application. There are two options you could try. Either install 32 bit version of the Oracle OleDb driver or right click the solution, select Properties and go to the Debugging section. There verify what Run64BitRuntime option says. If it is true, change it to false and see if this helps.

    Regards

    Piotr

    ...and your only reply is slàinte mhath

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

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