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