MS SQL Server ODBC - odbc connection drops after being idel for a while

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

odbc connection drops after being idel for a while

baraklo@gmail.com

2005-05-03, 11:23 am

Running ODBC application against SQL server 2000, ODBC connection is
established
successfully. If we then have an idle period of, say, 30 min, when app
is not accessing ODBC connection, and then an ODBC request is made - we
see an exception thrown, indicating disconnect.

I can't seem to find anything about this. Is there indeed something
like idle timeout? Where is it triggered - client, server, TCP layer?
Anyway to change this timeout? What's the best way to keep connection
"warm"? (except executing bogus select requests)..

Appreciate help.

M.

Sponsored Links