Well, the CLOSE appears to have been a red herring. Everything ran fine for several hours, then all at once a half dozen sessions didn't get disconnected. And again it appears to have been when there were a lot of simultaneous sessions. I'm leaning more and more to a threading issue with the Unidata ODBC driver.
On Wed, May 28, 2008 at 8:15 AM, Kevin King <[EMAIL PROTECTED]> wrote: > The client terminates fine. It's the server session that doesn't > disconnect. And in a weird twist that I'm still watching, I added a generic > CLOSE statement to close all the files being used by the subroutine before > it returns to the caller and since making that change the server has not > left any connections open. But like I said, I'm still watching this to see > if this was the silver bullet or merely a coincidence. > > -- -Kevin http://www.PrecisOnline.com ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/