Abdulla,

If you are going to be doing direct SPT with SQLExec() you should wrap it with your own function (or use a class that maintains your connection handle as well as wraps the function calls) and check the returned result of the SQLExec() call and if it's less than 0 call aerror() to determine the server error. If have an object in place it's pretty easy to have it attempt to reconnect and reissue the SQL statement.

>i m facing sometimes connectivity problems in Sql Server with Vfp 8.0
>
>The way i m doing is in the START of program
>i m using sqlstringconnect() to set the connection b/w vfp and sql server.
>connectivity is fine and retunrs a +ve connection handler.
>and store this handler value to a Public variable.
>
>So, whenever i need to upadate or Retrive the value from the sql Server
>just passing SQLEXEC(connethand,'Sql Satament ',alias)
> Sqlcommit(connethand) like this.
>
>Presntly, there are arnd 10 users using it and working fine,but some times
>i m geting connectivity probs.
>
>Can and body tell me the reason ?
>
>Sql having any connectivty time limit ? why becoz, some users are open the system
>from the moring to evining and some times keep idle for long times(minimise the Apps.).
>
>or Due to any connectivity sharing problem?