The 'Oraoledb.Oracle' Provider is not Registered on the local machine

Asked

Viewed 1,694 times

5

I have a problem that is limiting my work, it is the following, I created a Webservice with a connection string to an oracle database :

OleDbConnection con = new OleDbConnection("Provider=OraOLEDB.Oracle.1;Persist Security Info=False;DATA SOURCE=********;USER ID=******;Password=*******");

(*)’s are for hiding information, either way when I run the program to run mine query give me this mistake:

"The 'Oraoledb.Oracle1' Provider is not Registered on the local machine"

Can you explain why ? I have Oracle installed on the computer and already put the Target CPU in x64 and x86 and nothing solved.

c# asp.net oracle debug connectionstring

  • To try to help: https://stackoverflow.com/questions/6649363/microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine

  • He is using Ace.Oledb and not Oracle, the error is different, but thanks anyway ! :)

  • Here is a link: https://social.msdn.microsoft.com/Forums/pt-BR/79350e20-35b1-4f01-9f2c-929b8247e83b/o-provedor-oraoledboracle-no-register-na-mquina-localforum=504

  • http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

1 answer

2

You need to register the OLEDB driver:

1 - Check the folder containing the file OraOLEDB11.dll. ('oracle product 11.2.0 client_64 BIN')

2 - Open cmd as administrator

3 - Navigate to the folder containing the DLL. Ex: cd\oracle\product\11.2.0\client_64\BIN

4 - Run the record:

regsvr32 OraOLEDB11.dll

If there is no DLL on your computer, you must be missing the installation of Oracle Client

  • I tried to do this and it didn’t work, one thing, my bin was in a folder called server and not "Client_64"

  • try to put this dll inside the system32 or syswow64 folder

Browser other questions tagged c# asp.net oracle debug connectionstring

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