Shulou(Shulou.com)06/01 Report--

Recently, the Up master took over the project of connecting Oracle with C # and encountered all kinds of problems, the most serious of which was that he could not connect to Oracle with a connection string.

The following issue System.InvalidOperationException was thrown: the "OraOLEDB.Oracle.1" provider is not registered on the local computer.

And the error occurred.

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

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

Be aware that 32-bit and 64-bit on the Oracle Client side have been installed on this machine, and the environment variables have been configured. Even the Win 10 64-bit system should not fail, referring to a lot of articles on the Internet is useless!

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

Finally, configure the environment variables

Just restart VS.

PS:

Those who are good at English can refer to the following articles:

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.