RE: [sqr-users] SQR Oracle Drivers

["George Jansen" <GJANSEN@aflcio.org>]

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