[U2] ODBC Connection Hanging Around

[Kevin King]

I have a vbs script that connects to Unidata, calls a BASIC routine, returns
the results, and disconnects.  Well, it disconnects *most* of the time, but
not all of the time.  Does anyone have any ideas why the ODBC connection
would not disconnect EVERY time?

We're logging when the connection is opened and when the connection is
closed.  Last Friday's log shows 1174 opens and the same number of closes -
no errors.  Yet there were 12 sessions that did not get disconnected.  Any
ideas why?

-Kevin
http://www.PrecisOnline.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] ODBC Connection Hanging Around

[Kevin King]

I have a VBScript script that makes an ODBC connection to Unidata, calls a
subroutine, and returns the results.  Usually everything goes swimmingly,
but occasionally, and for no apparent reason, an ODBC connection will not
get disconnected from the Unidata side.  The ODBC session is instantiated
via:

DSN = "DSN=;Uid=;Pwd=__"
Session.Open DSN

And is closed via:

Session.Close
Set Session = Nothing

And yet occasionally UniAdmin will show one of these connections hanging on
unexpectedly.  Any ideas?

(Incidentally, while I would have preferred to write this via UO, the client
demanded this solution be written for an ODBC connection.)

-Kevin
http://www.PrecisOnline.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/