Re: Oracle 8.1.7 Client problem when using the command prompt

Hi again
Thanks so much for your response. I have now successfully logged in from the client when I used scott/tiger_at_servicename. What a relief! Louise

TurkBear <jgreco1_at_mn.rr.com> wrote in message news:<3qsfkuci94gea57ocj2abivmhtrosnq8jf_at_4ax.com>...
> 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 Thu Aug 01 2002 - 00:42:09 CEST