Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

OraOLEDB.Oracle provider is not registered on the local machine

I just migrated from XP to Win 7. I am guessing this error has to do with switching operating systems. I wrote a .net application that basically massages a large amount of data and then connects to a database and inserts/updates a table.

When I hit a button to connect to the database I run into the error regarding the oracle provider not being registered on my local machine.

A clear, step by step outline of how I can fix this quickly would be much appreciated.

The exact error message is:

'OraOLEDB.Oracle.1' provider is not registered on the local machine

like image 750
Jared Avatar asked Oct 15 '12 20:10

Jared


People also ask

What is OraOLEDB Oracle provider?

Oracle Provider for OLE DB (OraOLEDB) is an OLE DB data provider that offers high performance and efficient access to Oracle data by OLE DB consumers. In general, this developer's guide assumes that you are using OraOLEDB through OLE DB or ADO.

How do I find Oracle Oledb driver version in Windows?

Check version with right-hand mouse click -> Properties -> Details.


2 Answers

I had the same issue after installing the 64 bit Oracle client on Windows 7 64 bit. The solution that worked for me:

  1. Open a command prompt in administrator mode
  2. cd \oracle\product\11.2.0\client_64\BIN
  3. c:\Windows\system32\regsvr32.exe OraOLEDB11.dll
like image 104
Der Wolf Avatar answered Oct 09 '22 05:10

Der Wolf


I had the same issue using IIS.

Make sure the option 'Enable 32bit Applications' is set to true on Advanced Configuration of the Application Pool.

like image 27
Vagner Gon Avatar answered Oct 09 '22 07:10

Vagner Gon