Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2005
>>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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement