Re: ORA-12154 ?!!?!?

Mark D Powell <Mark.Powell_at_eds.com>:

> The ORA-12154 error message is "ORA-12154: TNS:could not resolve
> service name"
>
> As Sybrand mentioned there is information on the error in the
> referenced text (ch 17 with version 9)
>
> On the working platform is the environment variable tns_admin set? Is
> it set on the non-working platform? On Windows this variable can be
> set in the registry.

Hi!

I'm also getting ORA-12154. On the system (Windows 2000 Server SP4), I installed Instant Client 10g:

instantclient-basic-win32-10.2.0.2-20060508.zip and instantclient-odbc-win32-10.2.0.2-20060508.zip

In the system environment variables, I set:

TNS_ADMIN=C:\Oracle\instantclient_10_2\network\admin ORACLE_HOME=C:\Oracle\instantclient_10_2

To PATH, I appended: C:\Oracle\instantclient_10_2. I unzipped those two ZIPs mentioned further up to this directory.

C:\Documents and Settings\so_ask>type %TNS_ADMIN%\tnsnames.ora ORABDE.EUROPE.DELPHIAUTO.NET =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.233.30.8)(PORT = 1521))     )

    (CONNECT_DATA =
      (SERVICE_NAME = orabde.delphi)
    )
  )

After having done this, I ran C:\Oracle\instantclient_10_2\odbc_install and rebooted the system.

I'm now trying to setup a ODBC connection, a User DSN. In the ODBC configuration dialog, I selected the suggested name "ORABDE" in the list of "TNS Service Names". I then clicked on "Test Connection" and entered a valid username and password. Screenshot:

http://server4.pictiger.com/img/660378/computer-games-and-screenshots/ap-02--ora-12154-tns-could-not-resolve-the-connect-identifier-specified.php

As you can see on this screenshot, I got the following error message:

ORA-12154: TNS:could not resolve the connect identifier specified

There's only one tnsnames.ora file on the local harddrives of this system (content: see above and also at <http://vz6tml.pastebin.ca/211376>).

Thanks,

Alexander Skwar

-- 
You're dead, Jim.
                -- McCoy, "Amok Time", stardate 3372.7