>>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.

Since I'm the DBA, that won't happen, but good suggestion. :-) I'm looking at the VFP help... how does one check the connection to see if it is still valid?