Re: client failures with informix 7.2

In article <326D380D.2ED9@lucent.com>, Aaron Ogren <ogren@lucent.com> writes >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? Are you sure the thread never dies? Perhaps it is busy rolling back. ALternatively it may be processing a large query. It will only die when it tries to communicate with the client i.e. when it finishes rolling back or has done the query and is starting to return the query results. -- David Williams