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

Navigation
4

I have a problem that is limiting my work, this is the following, I created a WebService with a connection string for a database in oracle: 

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

(*) 's are to hide the information, anyway when I run the program to run my query give me this error:

  

"The 'OraOLEDB.Oracle1' provider is not registered on the site   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.

    
asked by anonymous 27.06.2017 / 15:37

1 answer

1

You need to register the OLEDB driver:

1 - Check the folder containing the OraOLEDB11.dll file. ('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.2.0\client_64\BIN

4 - Run the registry: 

regsvr32 OraOLEDB11.dll

If there is no DLL on your computer, the installation of Oracle Client

    
27.06.2017 / 16:17
How to fill form from combobox with database information? [duplicate] Check the number of copies that were printed