>>I am using SQLSTRINGCONNECT(cConnString) to connect to the SQL Server. Is there a way to set up a time out so that if the application is idle for, say 5 minutes, the connection is lost?
>
>Since you're alone on your box, why write code to test when you can simply open the services applet in the control panel and stop the SQL server service, just for testing?
First, thank you. I thought about it. But this will disconnect not because the application is idle but for "another" reason. And I can't test the case where - in case of a customer - the connection is lost due to being idle.
Unless you think it is the same, being idle or service has stopped.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
