How to solve this problem "The 'OraOLEDB.Oracle' provider is not registered on the local machine." ?
Posted on 2008-10-06
i am using VS 2005 and i try to open an oracle database using such code:
OleDbConnection connection = new OleDbConnection(connectionString);
ConnectionMonitor monitor = Monitor;
if ( monitor != null )
monitor.Add( new ConnectionInfo( connection ) );
when i try to run my web application, the error message pops up: The 'OraOLEDB.Oracle' provider is not registered on the local machine.
the error occurs at "connection.Open();".
i installed oracle 11g on my machine. and i try to add it in control panel > adminstrative tools > ODBC data source administrator > user DSN tab > click 'add' button > in 'create new data source' window, select 'oracle in oraodac11g_home1' > click 'finish' button > i got an error 'the setup routines for the oracle in oraodac11g_home1 ODBC driver could not be loaded due to system error code 126' > click 'ok' button > an message pops up 'could not load the setup or translator library'
how to solve this problem? i am really struggling with it.
thanks a lot