 Posted: 2011.November.25 - 2:49:00 PM - Section: Programming
If you have a 64 bit machine, running Windows 7 Professional 64 bit, and you've installed the Oracle 11g 64 bit client, you might think everything was working fine until you tried to run your .NET app (web or WinForm), and then you get this nasty message:
The 'ORAOLEDB.ORACLE' provider is not registered on the local machine
To fix the problem, you might have switched your connection string to say
Provider=ORAOLEDB.ORACLE (instead of Provider=MSDAORA.1), and added a reference to
Oracle.DataAccess (typically located at: C:\Oracle\11g\ODP.NET\bin\2.x\Oracle.DataAccess.dll). You might have even given the user account(s) for IIS rights to read and execute the files in the Oracle folder.
But the one thing that is rarely mentioned, is that you need to register the file called
OraOLEDB11.dll (typically located in: C:\Oracle\11g\BIN), and
restart the machine.
|