Xref: alice comp.databases.oracle.tools:28881
Path: alice!news-feed.fnsi.net!news.idt.net!netnews.com!feed1.news.rcn.net!rcn!newsfeed.stanford.edu!parc!news.wrc.xerox.com!not-for-mail
From: Vincent Teunissen <vincent.teunissen@nld.xerox.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: Connection Problem
Date: Fri, 23 Jul 1999 12:04:15 +0200
Organization: WCSIS
Lines: 23
Message-ID: <37983E1F.381FA899@nld.xerox.com>
References: <379821F8.412026D5@netscape.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.wrc.xerox.com 932724621 8407 13.204.9.119 (23 Jul 1999 10:10:21 GMT)
X-Complaints-To: usenet@news.wrc.xerox.com
NNTP-Posting-Date: 23 Jul 1999 10:10:21 GMT
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en

1. In the logon screen of TOAD you can set the sql*net according to your
database.
2. If the TNSNAMES.ora is not stored where it should be according to Oracle
you
    should set the TNS_ADMIN parameter to the directory where TNSNAMES.ora
    resides in regedit (don't include the file-name or the last backslash
in the value).

Kasi wrote:

> Hi everyone
>
> I've just downloaded TOAD trial version and I tried connecting to my
> database. For some reason it doesen't seem to recognise it. It comes up
> with an error message saying TNS could not resolve the service name. I
> had a look through TNSNAMES.ORA file and it has got all the info needed
> to connect. I tried ping command from my computer to the server where
> the database is sitting and it seems to work fine. I really suspect the
> place where the file is sitting. Even the path command shows the path
> where the file is. Any suggestions.
>
> Thanx...Kasi