locked
'oraoledb.oracle.1' provider is not registered on the local machine RRS feed

  • Question

  • Hi,

    I have a 64 bit machine running win 8.1.  I installed the oracle 12c 64 bit client and the 64 bit odac drivers.  However, all of my oracle connections are give me the "'oraoledb.oracle.1' provider is not registered on the local machine" error.

    thanks

    Scott

    Wednesday, March 23, 2016 7:07 PM

Answers

  • I got it to work once I installed the 32 bit ODAC drivers for Oracle:

    http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

    • Proposed as answer by Charlie Liao Thursday, March 24, 2016 6:04 AM
    • Marked as answer by Charlie Liao Wednesday, April 6, 2016 11:36 AM
    Thursday, March 24, 2016 1:33 AM
  • I get the error when I run from the visual studio 2012 IDE.

    So I already installed the 64 bit ODAC.  Can I also install the 32 bit one together with the 64 bit?

    Hi,

    • Visual Studio (BI Dev Studio)is a 32bit application.
    • SQL Server Management Studio is a 32bit application.
    • dtexecui.exe is a 32bit application.

    So you need to install the 32 bit provider to connect to your Oracle database.
    http://sqlblog.com/blogs/jorg_klein/archive/2011/06/09/ssis-connect-to-oracle-on-a-64-bit-machine.aspx

    Besides, you issue got solved, please mark the proper reply which will help other to find the correct solution.

    Regards,


    Charlie Liao
    TechNet Community Support

    • Proposed as answer by Charlie Liao Tuesday, April 5, 2016 1:54 PM
    • Marked as answer by Charlie Liao Wednesday, April 6, 2016 11:36 AM
    Thursday, March 24, 2016 6:04 AM

All replies

  • Hello Scott,

    Where do you get the error, when you run the package in SSDT (BIDS)? That's a 32 bit tool, you need the 32 bit Oracle data provider?

    Or do you get the error when you run the package in SSIS?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Charlie Liao Thursday, March 24, 2016 6:04 AM
    Wednesday, March 23, 2016 7:12 PM
  • I get the error when I run from the visual studio 2012 IDE.

    So I already installed the 64 bit ODAC.  Can I also install the 32 bit one together with the 64 bit?

    Wednesday, March 23, 2016 7:14 PM
  • The driver version is specific to the number of times you ran the Oracle installation.  Remove the .1 from the end of the provider.

    Wednesday, March 23, 2016 7:15 PM
  • sorry tom, i don't understand.  What do you mean when you say remove the .1 from the end of the provider?
    Wednesday, March 23, 2016 7:17 PM
  • The provider string on your computer is likely "oraoledb.oracle".  Change the connection string.


    Wednesday, March 23, 2016 7:19 PM
  • tom, here is what the connection properties look like in Visual Studio.  The Provider string in grayed out:

    Wednesday, March 23, 2016 7:23 PM
  • I got it to work once I installed the 32 bit ODAC drivers for Oracle:

    http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

    • Proposed as answer by Charlie Liao Thursday, March 24, 2016 6:04 AM
    • Marked as answer by Charlie Liao Wednesday, April 6, 2016 11:36 AM
    Thursday, March 24, 2016 1:33 AM
  • I get the error when I run from the visual studio 2012 IDE.

    So I already installed the 64 bit ODAC.  Can I also install the 32 bit one together with the 64 bit?

    Hi,

    • Visual Studio (BI Dev Studio)is a 32bit application.
    • SQL Server Management Studio is a 32bit application.
    • dtexecui.exe is a 32bit application.

    So you need to install the 32 bit provider to connect to your Oracle database.
    http://sqlblog.com/blogs/jorg_klein/archive/2011/06/09/ssis-connect-to-oracle-on-a-64-bit-machine.aspx

    Besides, you issue got solved, please mark the proper reply which will help other to find the correct solution.

    Regards,


    Charlie Liao
    TechNet Community Support

    • Proposed as answer by Charlie Liao Tuesday, April 5, 2016 1:54 PM
    • Marked as answer by Charlie Liao Wednesday, April 6, 2016 11:36 AM
    Thursday, March 24, 2016 6:04 AM