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
Solution 1:
I had the same issue after installing the 64 bit Oracle client on Windows 7 64 bit. The solution that worked for me:
- Open a command prompt in administrator mode
cd \oracle\product\11.2.0\client_64\BINc:\Windows\system32\regsvr32.exe OraOLEDB11.dll
Solution 2:
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.