Kevin,
It sounds as though the server is seeing the disconnects, but the client is
not getting the response back to recognize that it is truly disconnected.
Therefore the object is waiting on a response. I am not sure if the
driver is thread safe, but I would not count on it.
I might suggest
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
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
Sent: Wednesday, May 28, 2008 12:07 PM
Subject: Re: [U2] Re: ODBC Connection Hanging Around
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 little more information: The script in question is being called from a
Zeacom phone system. When a call comes in, the Zeacom infrastructure calls
a program named query.exe written by Zeacom) which then instantiates my
script. If there's only one call using the script at a time, everything