Home » RDBMS Server » Networking and Gateways » ERROR [08004] [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified (merged) (win2008,r2,10g 10.2.0.5 version 64bit )
ERROR [08004] [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified (merged) [message #575088] Sat, 19 January 2013 03:58 Go to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
hi guys,

did installed 10g 64bit verssion on windows 2008,service pack2 on 64bit version,installed the application called board software to connect to the database in order to make connection after installing board software which is also 64bit compatible version...

but giving the ERROR [08004] [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified

ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

kindly give me the solution for the above error





Re: ERROR [08004] [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified [message #575089 is a reply to message #575088] Sat, 19 January 2013 04:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12154: TNS:could not resolve the connect identifier specified
 *Cause:  A connection to a database or other service was requested using
 a connect identifier, and the connect identifier specified could not
 be resolved into a connect descriptor using one of the naming methods
 configured. For example, if the type of connect identifier used was a
 net service name then the net service name could not be found in a
 naming method repository, or the repository could not be
 located or reached.
 *Action:
   - If you are using local naming (TNSNAMES.ORA file):
      - Make sure that "TNSNAMES" is listed as one of the values of the
        NAMES.DIRECTORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA)
      - Verify that a TNSNAMES.ORA file exists and is in the proper
        directory and is accessible.
      - Check that the net service name used as the connect identifier
        exists in the TNSNAMES.ORA file.
      - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA
        file.  Look for unmatched parentheses or stray characters. Errors
        in a TNSNAMES.ORA file may make it unusable.
   - If you are using directory naming:
      - Verify that "LDAP" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Verify that the LDAP directory server is up and that it is
        accessible.
      - Verify that the net service name or database name used as the
        connect identifier is configured in the directory.
      - Verify that the default context being used is correct by
        specifying a fully qualified net service name or a full LDAP DN
        as the connect identifier
   - If you are using easy connect naming:
      - Verify that "EZCONNECT" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Make sure the host, port and service name specified
        are correct.
      - Try enclosing the connect identifier in quote marks.

   See the Oracle Net Services Administrators Guide or the Oracle
   operating system specific guide for more information on naming.

Regards
Michel
Re: ERROR [08004] [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified [message #575094 is a reply to message #575089] Sat, 19 January 2013 04:49 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
thanks michel really appreciate for such a quick response....

but i didnt about an other error where is this error comming from...


ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
Re: ERROR [08004] [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified [message #575100 is a reply to message #575094] Sat, 19 January 2013 04:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The second error comes from the first one.

Regards
Michel
oracle ODBC driver [message #575222 is a reply to message #575088] Mon, 21 January 2013 06:35 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
Installed oracle 10g 64bit 10.2.0.5 version on windows 2008 r2 64bit installation was successfull done,but the problem is when we connecting database by MICROSOFT ODBC source administrator,

ITS giving an ODBC driver error beccause only 32bit ODBC drivers got installed by Microsoft,how should i installed 64bit ODBC drivers in order to get connected by ODBC source administrator


DSN=SHAKES;UID=AMIS2000;

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

ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

Thanks in advance.....
Re: oracle ODBC driver [message #575223 is a reply to message #575222] Mon, 21 January 2013 06:43 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is useless to repost the same question, the answer is the same one.
You should better investigate in fixing the problem instead of wasting everyone's time repeating the same thing.

Regards
Michel
Previous Topic: ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
Next Topic: c program call from plsql
Goto Forum:
  


Current Time: Fri Apr 19 01:25:41 CDT 2024