ora 12154 tns could not resolve the correct identifier specified

[JustinianWagner]

I am facing the following problem:

windows 7 64 bits, labVIEW 2012 32 bits, oracle client 10.2.0.1.0 (32 bits).

I created a DSN from Data Sources (ODBC) (the 32 bit version of this which is %windir%\syswow64\odbcad32.exe) pointing to an Oracle 10g instance.

I test the DSN through this (ie. Data sources (ODBC) and the connection is successful (which means that the tnsnames.ora is correct).

I use the "DB Tools Open Connection.vi" in order to get connected to this database passing as parameters the DSN above, the user name and password.

I get the error:

ADO Error: 0x80040E4D
Exception occurred in Microsoft OLE DB Provider for ODBC Drivers:

[Oracle][ODBC][Ora]ORA-12154: TNS could not resolve the correct identifier specified

any help will very appreciated

thanks in advance

[mikeporter]

What is the connection string you are using?

Mike...

[Richard_Smith]

Hi Mike, 

I was reading in the chapter 3 of the Database Connectivity Toolkit information related to how to connect to different database types. If the database is ODBC you can create a DSN, and this chapter shows how to do it. Also, If your database is ADO or OLE DB, you can set a UDL to connect to it and this chapter also shows how to do this. 

I recommend you to check this manual, chapters two and three for your purposes. 

You can get this manual here: 
http://www.ni.com/pdf/manuals/321525c.pdf 


Regards, 

[JustinianWagner · Accepted solution]

hello everybody.

I already solved the problem  (working until late Saturday).

the solution was to install the latest Oracle client, namely: Oracle 11g Release 2 CLIENT for Windows 32 (11.2.0.1.0).

Now everything runs OK.

I also tested it in Widows 7 32 bit (the same .vi and the same Oracle client). It also runs OK.

Thans a lot.