Re: ORA-12154 TNS could not resolve service name through Automa

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 15 Nov 2005 08:51:33 GMT
Message-ID: <1132044688.889247@proxy.dienste.wien.at>

ShadowAssassin <tariq.khan_at_gmail-dot-com.no-spam.invalid> wrote:
> I can't connect to my Oracle9i database when the connection request is
> made via automation, i.e. I have Visual Basic call another dll which
> inturn makes an ODBC connection request. (Making direct connections
> on the other hand works.)
>
> When I try I get the following error message:

>> state was 08004, code 12154, message [Oracle][ODBC][Ora]ORA-12154:

> TNS:could not resolve service name[ODBC][Ora]ORA-12154: TNS:could not
> resolve service name[/quote:0498496778]
> What could be wrong?

[...]
> The Second file contains:

>> (3720) [11-NOV-2005 17:12:55:442] --- LOG CONFIGURATION INFORMATION

> ENDS ---

>> 
>> (3720) [11-NOV-2005 17:12:55:442] ntvllt: entry
>> (3720) [11-NOV-2005 17:12:55:442] ntvllt: exit
>> (3720) [11-NOV-2005 17:12:55:442] nigini: entry
>> (3720) [11-NOV-2005 17:12:55:442] nigini: Count in NI global area

> now: 1

>> (3720) [11-NOV-2005 17:12:55:442] nigini: Count in NI global area

> now: 1

>> (3720) [11-NOV-2005 17:12:55:442] nrigbi: entry
>> (3720) [11-NOV-2005 17:12:55:442] nrigbni: entry
>> (3720) [11-NOV-2005 17:12:55:442] nrigbni: Unable to get data from

> navigation file tnsnav.ora

>> (3720) [11-NOV-2005 17:12:55:442] nrigbni: exit
>> (3720) [11-NOV-2005 17:12:55:442] nrigbi: exit
>> (3720) [11-NOV-2005 17:12:55:442] nigini: exit
>> (3720) [11-NOV-2005 17:12:55:442] niqname: Hst is already an

> NVstring.

>> (3720) [11-NOV-2005 17:12:55:442] niqname: Inserting CID.
>> (3720) [11-NOV-2005 17:12:55:442] nigtrm: Count in the NI global

> area is now 0 [## A successful log-in is different from here on -
> should say 'niotns: entry' ##]

>> (3720) [11-NOV-2005 17:12:55:442] nrigbd: entry
>> (3720) [11-NOV-2005 17:12:55:442] nrigbd: exit
>> (3720) [11-NOV-2005 17:12:55:442] nigtrm: Count in the NL global

> area is now 0 nigtrm: Count in the NL global area is now
> 0[/quote:0498496778]

Put the following line into sqlnet.ora:
TRACE_LEVEL_CLIENT = SUPPORT Then the trace file should contain much more, and maybe you can find out where it goes wrong.

Yours,
Laurenz Albe Received on Tue Nov 15 2005 - 02:51:33 CST