Re: How to set Timeout ??
Posted in 1996
Topics: Error Codes & Troubleshooting
In article <31816A4F.FA4@w3spider.com>, Aziz <aziz@w3spider.com> wrote: > Hi , > > Is there a concept of Database connection timeout in Informix > unlike Oracle. (where U can set sqlnet.expire_time in sqlnet.ora). > > If so how to set it in Informix and what is the error code > returned . > > Thanks If you are using client s/w pre release 7.x then you may be out of luck. I have the problem that if I connect from my application to an online on a server that has died (If I knew it was dead I wouldn't try to connect) my program hangs on the connect statement. There doesnt seem to be any way to set a timeout to abort the connect after so many seconds. The client s/w I'm running is release 6.0 for SVR4. Informix Technical support does not have any solution. Anyone else have any idea how to do this? Ken M. -- Kenneth McCarthy Northern Telecom Ottawa, Ontario Canada (613)765-5226