Re: SQRW Unable to Connect to Oracle

[Cheryl Poole <cpoole@COGNEX.COM>]

I'm pretty new to this, but here's what we experience.  When I move from one
environment to another,  dev to prod, I sometimes get an error message
saying something like, 'TNS file not found', so I can't always log into
another database directly.  In our shop it has something to do with an
accidental deletion, or improper migration of TNS file.  The sysadmin hasn't
gotten to this fix yet, but you might check with your group.  The solution
for us is to log off and back on.  Sloppy but effective.
Cheryl

> -----Original Message-----
> From: Smith, James O. [SMTP:SMITHJO@pgocm2.ksc.nasa.gov]
> Sent: Wednesday, September 06, 2000 9:38 AM
> To:   SQR-USERS@list.iex.net
> Subject:      SQRW Unable to Connect to Oracle
>
> Hello Everyone;
>
> I am stumped. I am trying to run SQRW.EXE (located in my Ora/Bin folder)
> and
> receive the following error:
>
> (SQR 4701) Cannot Logon to the database
>
> I have searched the archives and found many references to this error,
> unfortunately, none of them helped
> me with my problem. The SQRW executable has the following specs:
>
> SQR/4.3.4/PC/Windows NT 4.0/Oracle 7.3.4/June 03 1999
>
> I am attempting to connect to an Oracle 8.1.6 database using Windows NT
> 4.0
> SP 5.
>
> I am running SQL Plus from the same computer and connect to Oracle without
> a
> problem so the
> "TNSNAMES.ORA" file is set up correctly. The SQRW executable does not seem
> to care if the
> TNSNAMES.ORA file exists or not - I get the same error (SQR 4701) no
> matter
> if the TNSNAMES.ORA
> file is present or removed.
>
> The ODBC version of SQRW.EXE (located in my Odb/Bin folder) runs without a
> problem.
>
> If anyone has any suggestions on correcting this problem, or if you could
> point me to a document or two
> that might be of some help, please reply - Any help would be appreciated.
> Thank you.
>
> Jim