The system. Data. oracleclinet connection method prompts a TNS error on an x64-bit machine.

One of the processing methods is:

Connect web. config to a string

<Add name = "Main" connectionstring = "Data Source = me11g; persist Security info = true; user id = WQ; Password = xyha; Unicode = true;" providername = "system. data. oracleclient "/>

 

Modify:

<Add name = "Main" connectionstring = "Data Source = (description = (address_list = (address = (Protocol = TCP) (host = 192.168.1.12) (Port = 1521 ))) (CONNECT_DATA = (SERVICE_NAME = smsvr); persist Security info = true; user id = WQ; Password = xyha; "providername =" system. data. oracleclient "/>

 

However, there is a problem. Some methods may not be universal. The best way is to install an x64 Oracle client. This problem can be solved.