If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

We have an oralce 816 client on Win NT with third party software connecting to Oracle816 DB on linux using "Merant ODBC" driver. I am getting lot of "TNS-12502: TNS:listener received no connect data from client messages" in the listener log file. I checked the tnsnames.ora on the client and it does have CONNECT_DATA specified. Does anyone know what is happening?

It's happening consistently. I checked the tnsnames.ora file and the entries are correct.

We have an NT server with a third party software and Oracle client software 8.1.6. Third part software makes a connection to the Oracle Server dirver on linux using ODBC and it needs the connection open all the time. Also this is production environment i can't afford to bring down the NT server.

If i try to connect with another application (Excel, Acess etc..) and if i get this error "TNS-12502: TNS:listener received no connect data from client " how can i figure out which app is causing this error.

in the tnsnames. set the service_name = ... instead of SID. You can know the service name from the initSID.ora file or by querying the v$parameter as sys or system. Check your ODBC connection configuration to see whether there are any timeouts defined.