"ORAOLEDB.ORACLE.1" Provider is not registered on the local computer--handling of the problem

Recently the up master took over the C # connection to Oracle's project, encountered a variety of problems, the most serious is the connection string is not connected to Oracle.

Throws the following question System.InvalidOperationException: "ORAOLEDB.ORACLE.1" Provider is not registered on the local computer.

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M02/9D/E5/wKiom1mILfPwHorMAABUHEMwXDk308.png-wh_500x0-wm_ 3-wmp_4-s_4111817542.png "title=" Invalid operation. The connection is closed. PNG "alt=" Wkiom1milfpwhormaabuhemwxdk308.png-wh_50 "/>

and an error occurred.

In System.Data.ProviderBase.DbConnectionClosed.get_ServerVersion ()

In System. Data.OleDb.OleDbConnection.get_ServerVersion ()

Be aware that the machine has 32-bit and 64-bit installed on the Oracle client side, and that the environment variables are already configured. Even if the win 10 64-bit system should not be able to, refer to the online many articles are no use!

Finally, a foreign friend of the method to successfully solve the problem. The key is to download a instantclient-basic-win-x86-64xxxx, unzip it and put it in the C:\Oracle\ directory

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M01/9D/E5/wKiom1mILxPSGxIEAABHz9K6_-E206.png-wh_500x0-wm_ 3-wmp_4-s_2659120091.png "title=" File path.png "alt=" Wkiom1milxpsgxieaabhz9k6_-e206.png-wh_50 "/>

Finally configure environment variables

650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M02/9D/E5/wKioL1mIL1zCfgH2AAA4A1PgIME682.png-wh_500x0-wm_ 3-wmp_4-s_2766750234.png "title=" environment variable. PNG "alt=" Wkiol1mil1zcfgh2aaa4a1pgime682.png-wh_50 "/>

Restart vs on it.

Ps:

English good can refer to the following articles:

Http://www.dbatoolz.com/t/installing-oracle-instantclient-basic-and-instantclient-sqlplus-on-win32.html

This article is from the "to IS EX" blog, please make sure to keep this source http://gleolee.blog.51cto.com/10632675/1954256

"ORAOLEDB.ORACLE.1" Provider is not registered on the local computer--handling of the problem