OraOLEDB.Oracle provider is not registered on the local machine

c# .net windows oracle

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

c# .net windows oracle

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.

c# .net windows oracle

Do the following test:

Open a Command Prompt and type:tnsping instance_name

where instance_name is the name of the instance you want to connect (if it's a XE database, use "tnsping xe"

If it returns ok, follow steps of Der Wolf's answer. If doesn't return ok, follow steps of Annjawn's answer.

It solved for me in both cases.

CodeHunter