Solving 'OraOLEDB.Oracle.1' provider is not registered on the local machine issue.

We can solve 'OraOLEDB.Oracle.1' provider is not registered on the local machine issue by just registering it using below command in VS console: regsvr32 %ORACLE_HOME%\BIN\OraOLEDB10.dll