odbc connection drops after being idel for a while

Tech-Archive recommends: Speed Up your PC by fixing your registry

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.

.

Relevant Pages

  • Re: ODBC to SQL Server Express?
    ... >Server connection, in both the system's ODBC connection manager and the ... >>>Can I create an ODBC connection to SQL Server Express? ... >>>Server Express and Visual Web Developer Express (for a database frontend ... I need to access the SQL Server Express databases via ODBC. ...
    (microsoft.public.data.odbc)
  • RE: Timeout Expired
    ... > I have a table in SQL Server 2000 with 3.5 million rows in it, ... I have a non-unique index ... > the query takes approximately 1.5 minutes to complete when run through Query ... > up the timeout period on the server or on the ODBC connection? ...
    (microsoft.public.sqlserver.odbc)
  • Re: Web enable db w/ pass thru
    ... if your intranet fast enough - then it can work in it also. ... > I have an Access 2000 database that has several ActiveX ... > db that runs on the server hosting SQL Server, ... > ODBC connection and connection string. ...
    (microsoft.public.access.developers.toolkitode)
  • Re: Is there a ADO.NET equivalent for ADOX
    ... Greg - No it isn't just SQL Server and that's the challenge. ... difficulty setting up the ODBC connection to read the "data". ... The database may be of any technology - maybe only able to be connected ... With VB6 and ADOX I can iterate through an ADOX.Catalog and do this. ...
    (microsoft.public.dotnet.framework.adonet)
  • Create Table in SQL server (Visual basic.Net )
    ... I am using ODBC connection to connect one database, ... which means a table will be created on SQL server and all ... Is there a simplest way to fulfill above aim in Visual Basic code? ... setup each table structure and insert the data, ...
    (microsoft.public.dotnet.general)