OCIServerAttach fails to reconnect with error: TNS could not resolve service name. Make no mistake, this works the first time but once i close connections from database side (manually), the application is designed to detect that and reconnect. I free almost all handlers and even call OCIServerdetach but when i reconnect any process, i get the above error. I am using oracle 8.1.7, strange enough oracle 8.0 version works fine. If I manually stop all processes (basically refreshen) and start the application again it connects successfully.

any ideas ??