Failed to test connection. The ‘OraOLEDB.Oracle’ provider is not registered on the local machine.
本机安装的oracle11g的64位客户端，使用.net开发，使用oledb组件连接数据库，报错
The MSDAORA.1 provider is not registered on the local machine
后来把连接字符串改成
Provider=OraOLEDB.Oracle;DataSource=MyOracleDB;UserId=myUsername;Password=my...
报错
The ‘OraOLEDB.Oracle’ provider is not registered on the local machine.
The ‘OraOLEDB.Oracle’ provider is not registered on the local machine.
解决方法：安装oracle64位客户端，选择oledb相关组件。安装后，改系统环境变量path，home_1为首选
参考：http://blog.csdn.net/guoneng_wei/article/details/39577349
原文链接：https://www.f2er.com/oracle/209197.html