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

'OraOLEDB.Oracle.1' provider is not registered on the local machine issue can be solved using regsvr32 command

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