Re: defunct sqlexec w/SE&ODBC

In article <34BA8C99.3FCF@sco.com_no_spam_please>, Allan Gould <allang@sco.com_no_spam_please> writes >David Williams wrote: >> >> In article <6959hd$6ed@cssun.mathcs.emory.edu>, "Ron M. Flannery" >> <rflanner@speedlink.net> writes >> > >> >I have a client who is using Microsoft Access to access an Informix-SE 7.1 >> >database on DEC Unix 3.2c. We're using pass-through queries and the >> >Intersolv Informix 2.5 ODBC driver. Clients are NT 3.51, Win95, and NT 4.0. >> > The problem is that after queries are completed, the sqlexec process >> >hangs and then becomes defunct. There is no way for us to access the CLI >> >routine that will release the server resources. Any ideas? >> > >> We had a similmar problem with SCO Open Retriever. It was a bug in the >> ODBC driver. > >Having either rpc or sqlexec processes lying around was indeed a bug in >our ODBC Driver, but about three years ago. We have long since fixed >it, by putting in inactivity timers, either at the TCP/IP level or at >the data level. I hope this information >has filtered through to you. > Oops, sorry getting a bit brief in my old age..meant to say that was in 1995 and SCO were great to us, gave us the next enhancement version free. Not hust a patch but more features as well, it worked first time and really blew our minds with performance!!! I like SCO Open Retriever...it rates up there with Openlink. >> David Williams -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care