Re: client failures with informix 7.2

Aaron Ogren <ogren@lucent.com> wrote: :I am developing a client/server application using informix 7.2/Solaris :2.5 as the server and PCs running MSAccess2.0 as the client with :InterSolve DataDirect 2.11 ODBC driver and I-Net 5.x. :I have noticed that when a client dies in the middle of a transaction :(between the ODBC calls BeginTrans and CommitTrans), the thread on the :server never dies and never releases the locks. The same thing happens :when I kill a dbaccess session, so the problem does not seem to be :limited to ODBC connections. : :Does anyone know a workaround to this problem? Yes. Change to the openlink ODBC drivers and check into the keep alive system they support. That is supposed to terminate the connection nicely with a rollback work if you client application stops for any reason whatever. We are about to test this so I only said "supposed" above, I don't yet know how well it works. You may find you gain in performance as well with the Openlink drivers. PS. People may start believing I am somehow affiliated with Openlink. I am no, I don't even own any shares in the company. I just like good products. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company