Re: Oracle 8.1.7 Client problem when using the command prompt

If the Database is not on the client PC you need to specify the tnsnames.ora alias or have a LOCAL=alias environment variable ( or, if really a bad design, in the registry) Try
SqlPlus scott/tiger_at_whatever

acfield_at_xtra.co.nz (Louise) wrote:

>Hi
>I would be grateful for some urgent help with a problem I have
>encountered with attempting to run the SQL Plus utility from the
>command prompt on a Windows 2000 platform PC with Oracle 8.1.7 Client
>installed. I receive the message "TNS protocol adapter error" when I
>type
>
> sqlplus scott/tiger
>
>If I type this line at the command prompt on the 8.0.5 server the
>login succeeds. This login succeeds from the SQL Plus utility on the
>client PC!
>I need to be able to log in from the command prompt on the client PC
>so I can call the SQL Loader utility using a shell call from a VB
>application.
>Thanks in advance
>Louise

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Jul 31 2002 - 16:27:41 CEST