Error: The provider 'ORAOLEDB.Oracle' is not registered on the local machine

Asked

Viewed 1,566 times

2

Error: The provider 'ORAOLEDB.Oracle' is not registered on the local machine.

I need to do some maintenance on a project. NET , with Oracle 12c version and my operating system is 64bit Windows 10 Education. I’m encountering this error

The provider 'ORAOLEBD.Oracle' is not registered on the local machine.

These were the following attempts I made found on the internet:

  1. command via CMD: cd C: app client User product 12.2.0 client_1 bin c: Windows system32 regsvr32.exe Oraoledb12.dll On Attempt do the manual record, however I was unsuccessful it still continues presenting the error.
  2. I already uninstalled Oracle and installed again.
  3. I made settings in the "environment variables" on my system operational.
  4. I changed the "platform target" to x64 and x86 in BUILD within the platform . NET Installed Oracle Client "Administrator"
  5. I installed via CMD command the Odac122010xcopy_x64 folder

Those are the solutions I found and none of them solved my case.

c# oracle windows-10 oracle12c

  • Have you checked if you have the 64 bit client installed in another folder? If so, have you registered it?

  • Yes, I already checked it and also I registered it via CMD to be sure and even so it continues with the same error

1 answer

1

Usually the problem is just the lack of registration even. Even already exists answers on the website that solves that same problem.

The standard solution is usually the steps below, according to the answer that Linkei:

  1. Open command prompt as administrator
  2. Execute: cd \oracle\product\11.2.0\client_64\BIN (Or the way your client is 64 bits)
  3. c:\Windows\system32\regsvr32.exe OraOLEDB11.dll

Be sure to open the CMD as an administrator.

But since you said you already did this for both clients and were unsuccessful, do the checks listed below:

  1. To the Windows 7 or Windows 10 try to follow the same steps previously informed but using the path C:\Windows\SysWOW64\Regsvr32.exe to the step 3.

  2. Use the excerpt below to identify if your application is running 64 or 32 bits and try switching between one and the other after registering the Oraoledb11.dll.

    if (Environment.Is64BitProcess)
{
    Console.WriteLine("64 Bits!");
}
else
{
    Console.WriteLine("32 Bits!");
}
  3. Check the environment variable PATH and if there is in it 32 or 64 client path and try to switch between them and test the applying.

I’ve had this same problem in an application (but with oracle 11g), and in my case the installation using the Xcopy_64bits that solved the problem. If none of this solves your case since most of you have already tried, consider trying again with xcopy installation.

I tried to give a lot of detail in the answer, because a lot of the known solutions you reported you already tried to do, but very likely one of them will solve your problem. Maybe one of these options lacked some detail.

Browser other questions tagged c# oracle windows-10 oracle12c

You are not signed in. Login or sign up in order to post.