[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] SQR Oracle Drivers

Hi George,

I am able to TNSPing and connect using SQL*Plus.
I can use Oracle Forms successfully on this machine.

Thanks

-----Original Message-----
From: sqr-users-bounces+vito.campanelli=mcgill.ca@sqrug.org
[mailto:sqr-users-bounces+vito.campanelli=mcgill.ca@sqrug.org] On Behalf
Of George Jansen
Sent: Friday, June 11, 2004 11:42 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] SQR Oracle Drivers

The first thing is to make sure that the SQL*Net layer is OK on your
machine.

What do you have in the Oracle client install on your machine? At a
minimum, there is probably TNSPING (for old versions, TNSPING80). If
you

tnsping yourdb

Can it resolve the name and find the listener? If not, your naming
configuration is wrong.

If you can TNSPING, then you are at least finding some listener
somewhere. At this point you need to find out whether you can reach the
proper instance. The simplest way is using SQL*Plus if you have that. If
not, use the Network Configuration Assistant and edit your service.
Don't make any changes, but at the end indicate that you want to test
the connection. If the connection is set up properly, you should either
get a success indicator, or an invalid username/password message. If
not, you may get a more useful error message.

George Jansen 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users