>Hi,
>
>In addition to the time out you set for your SQL Server connection in your VFP application, does SQL Server itself set a time limit on the connection? And how do you determine if your connection has timed out? For example, say at the top of the application or a module you connect to SQL Server and get a connection handle. Then you pass this connection handle to SQLEXE() function. Which fails if your connection is timed out. So I guess the failure of SQLEXE will tell your application that connection has timed out. Is there another method to determine it?
>
>TIA.
Dmitry,
It is a good idea to make your own sqlconnection class
In its init it accepts the connection string and stores it.
You then call methods of that class - the same that exist now, but without the connection handle
The class keeps its own connection handle, and if there's a connection failure on an sqlexec() or so, you can reconnect and repeat the sqlexec
The class itself defines its behaviour, when to connect, when to disconnect, etc
I think this may make life easier for you - well the sql part, this is
Gregory