[Solution] win7 x64 vs SQL statement connection ora-12154: tns: Unable to parse the specified connection identifier

Source: Internet
Author: User

[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.
 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.