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.

Thanks