Re: ORA-12154 ?!!?!?

From: Alexander Skwar <alexander_at_skwar.name>
Date: Tue, 24 Oct 2006 15:34:41 +0200
Message-ID: <1498206.vujhZV3Kta@work.message-center.info>

HansF <Fuzzy.Greybeard_at_gmail.com>:

> On Tue, 24 Oct 2006 13:27:45 +0200, Alexander Skwar wrote:
>

>> 
>> 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)
>>     )
>>   )
>> 

>
> Could not resolve service name means exactly that ... whatever you put
> after the @ in the connect string could not be translated to
> ORADBE.EUROPE.DELPHIAUTO.NET
I selected it from the drop down list in the ODBC configuration dialog. So, I selected ORABDE.

> There are several basic possibilities, the most common being
>
> 1) the client could not find the tnsnames.ora
> - you appear to have that resolved

Yep.

> 2) you did not enter the above string exactly as written
> - hidden characters in a connect string can do funny things

I selected it from the presented values. That should be correct, no?

> 3) you have a sqlnet.ora that contains default_domain setting and you
> enter a service alias oradbq

I've got no sqlnet.ora on my system.

Anyway. When I use ORABDE.EUROPE.DELPHIAUTO.NET, I can create the ODBC connection.

Alexander Skwar

-- 
"The world is beating a path to our door"

  -- Bruce Perens, (Open Sources, 1999 O'Reilly and Associates)

Received on Tue Oct 24 2006 - 08:34:41 CDT