c# - OraOLEDB.Oracle provider is not registered on the local machine

Question

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

Answer 1

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 oracleproduct11.2.0client_64BIN
3. c:Windowssystem32 egsvr32.exe OraOLEDB11.dll