ADO Connection Time-Out Length

Posted on 2014-03-02
Medium Priority
Last Modified: 2014-03-03
I have a visual basic 6 that relies on internet connectivity.  We use it to time races (5k, marathon, triathlon, etc).  I use the following connection string to my server:

srvr_conn.Open "Provider=SQLNCLI10;Server=,1433\SQLExpress;Database=db;Uid=uid;Pwd=pwd;"

How long will this connection stay open?  Is that a server setting?
Question by:Bob Schneider
LVL 75

Accepted Solution

Anthony Perkins earned 2000 total points
ID: 39899557
As long as you
1. Do not close it,
2. The connection object does not go out of scope
3. Your spid is not manually KILLed
4. The SQL Server does not shut down.

Author Closing Comment

by:Bob Schneider
ID: 39900038
Thanks so much.

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question