Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!news.maxwell.syr.edu!sn-xit-03!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: Will only recognize FIRST listing in TNSNAMES file Date: Thu, 10 Oct 2002 21:34:51 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.demon.nl References: <54df0379.0210101007.18e9c2e1@posting.google.com> X-Newsreader: Forte Agent 1.92/32.572 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 28 Xref: newsfeed1.easynews.com comp.databases.oracle.server:163769 X-Received-Date: Thu, 10 Oct 2002 12:33:46 MST (news.easynews.com) On 10 Oct 2002 11:07:07 -0700, PrivateBenjamin@hushmail.com (April) wrote: >Strange one, > >trying to connect to an Oracle7.3 (I know, I know) db through TOAD or >a DSN for MS -Access, we are receiving the error "could not resolve >TNSNAMES". However the correct TNSNAMES are in the file and the same >file is used successfully by other users. > >If the db instance to which we are trying to connect, is put first in >the file, then the connection works, ONLY and ONLY if the db is first >in the file????? > >Any thoughts, >thx >April You must have syntax errors in your tnsnames.ora. Syntax errors result in ora-12154. Please post your tnsnames.ora file Regards Sybrand Bakker, Senior Oracle DBA To reply remove -verwijderdit from my e-mail address