>How long will a SQL Server connecttion stay active without refreshing? For example using the SQLCONNECT as follows: lnFileHandle = SQLCONNECT("ecpvgh")
>
>I have a report module that runs on our server, and it could be running for weeks or months without restarting it. Will the connection to SQL Server eventually time out if I don't use it for a while?
Not automatically, no. However, it isn't a good idea to leave an unused connection open. If, for some reason, something forces the connection to be cut - a DBA has that power - then you risk crashing your app unless you test the connection before trying to use it again.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
