none
'System.Data.OleDb' provider is not registered on the local machine RRS feed

  • Question

  • Hi,

    I am trying to establish connection between Visual Studio 2008 and Oracle, but getting an error saying "'System.Data.OleDb' provider is not registered on the local machine".

    I even added the library " using System.Data.OleDb ".

    Can anyone help me how can I stablish the connection and resolve this error.

    My connection string is as below,

    OleDbConnection conn = new OleDbConnection("Provider=System.Data.OleDb;data source=Marketing;User Id=Abhi;Password=XYZ;initial catalog=MRTMARKETING;integrated security=sspi");

    Thanks in adavnec for your help.

    Regards,

    Abhishek

    Wednesday, February 27, 2013 6:06 AM

Answers

  • The Provider name in the connection string should be either msdaora (Microsoft's OLEDB Provider for Oracle) or OraOLEDB.Oracle (Oracle's OLEDB Provider).

    You may want to consider using ODP.NET, Oracle's native .NET library. Connection string info below for the various providers:

    http://www.connectionstrings.com/oracle


    Paul ~~~~ Microsoft MVP (Visual Basic)

    • Marked as answer by Alexander Sun Monday, March 11, 2013 8:18 AM
    Wednesday, February 27, 2013 3:08 PM

All replies