RE: connectivity problem

Anil,

1. Check whether your listener services are up or not. On unix, the command is --- lsnrctl and this command is in --- $ORACLE_HOME/bin. If the service is not up, start the service and try to connect. The reason - When you are connecting at the server, the connection does not require listener. But, when you are trying to connect from client, you require a listener service on the server.
2. If the above fails, Check your tnsnames.ora file. You did not tell on what server you have Oracle. Generally, you can find tnsnames.ora in the path on Unix --- $ORACLE_HOME/network/admin. Also, check your sqlnet.ora. In both of these files, see how your service name --- acroweb is defined i.e., what is the secondary name. It should be generally end like --- acroweb.world.
3. If the above fails, create a new service name using Net8 Eeasyconfig

Rao

teki01_at_mediaone.net

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rajesh Dayal Sent: Sunday, September 03, 2000 9:26 AM To: Multiple recipients of list ORACLE-L Subject: FW: connectivity problem
hi,

If i connect using anil/anil at the server it connects but here if i connect as anil/anil_at_acroweb it should connect ,it should but it is not connecting............ i've made a dsn and connecting well over here but see the problem is there in our other office and the people out there are taking instructions from us.. and the odbc test from both client and server are failing...... tell me what i can do to make the odbc test successful.. i'm using oracle8 odbc driver to connect to database. waiting Received on Mon Sep 04 2000 - 09:06:42 CDT