& Quot; the "OraOLEDB. Oracle.1" provider & quot; is not registered on the local computer,

"Two solutions to the" OraOLEDB. Oracle.1 "provider" issue are not registered on the local computer,
Problem:

In the C # program, you must use Provider = OraOLEDB. Oracle.1 to access the ORACLE database. However, an exception was reported during program execution: the "OraOLEDB. Oracle.1" provider was not registered on the local computer ......

Solution 1

Register ORAOLEDB. dll again. Open the doscommand window as an administrator and enter:

Regsvr32 "F: \ oracle \ app \ product \ 11.2.0 \ dbhome_1 \ BIN \ OraOledb11.dll"

Solution 2

1. Download ODAC112030Xcopy_32bit (select the corresponding version based on your own situation)

32-bit Oracle Data Access Components (ODAC)

2. Unzip the package and install it:

Install all F: \ oracle \ app \ product \ 11.2.0 \ Client_2 odac

3. Add the system environment variable path:

F: \ oracle \ app \ product \ 11.2.0 \ Client_2; F: \ oracle \ app \ product \ 11.2.0 \ Client_2 \ bin;

* Extension: how to install and uninstall the Oracle Data Access Component ODAC