[Solution] win7 x64 vs SQL statement connection ora-12154: tns: unable to resolve the specified connection identifier first vomit slot: win7 x64 special, many places are very special, therefore, installing a lot of software is useless. Background: Operating System: win7 x64 Development Environment: VS2008 Database: OracleDB11gx64, Oracle_Client11gx86, and PL/SQL9.0.6 the preceding exception occurs when PL/SQL or client is used for connection, please bypass Google to query other solutions, a large number. In the process of connecting Oracle with vs, the error [unable to parse the specified connection identifier] always occurs. After a long time, I don't know what the problem is. There is no problem with PLSQL connection, the connection only fails in the code. Solution: reconfigure the deployment platform. For example, let's talk about the cause of the problem (I guess): At first, I was crazy. I found a problem for a long time and didn't know why. Later I thought it might be a problem with the operating system, because I encountered some problems when installing Oracle. From the operating system, it is the issue of VS's release platform. My Oracle Database is installed with x64 and does not have configuration information such as Listener and service set in it.
My Oracle Client is installed with the x86 version, and I configure Listener and other configuration information in the Oracle Client. However, in my VS, I chose Any CPU (default) and my computer is 64-bit. Therefore, the program may call the configuration information in DB (64-bit) by default, I have not configured this, rather than calling the configuration information of the 32-bit client that I have configured. Therefore, the connection identifier cannot be parsed. Therefore, if the above assumption is correct, adding a listener to the DB should also work.