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
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.
Check version with right-hand mouse click -> Properties -> Details.
I had the same issue after installing the 64 bit Oracle client on Windows 7 64 bit. The solution that worked for me:
cd \oracle\product\11.2.0\client_64\BIN
c:\Windows\system32\regsvr32.exe OraOLEDB11.dll
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With