PMFJI, but how do you check for a valid handle when you are using Cursor Adapter? With CA, the cursor gets/loads the records. Then on Tableupdate() the SQL server table is updated. This procedure of calling Tableupdate() is very frequent. Do you check for a valid handle before each and every Tableupdate()?
>Before
every attempt to read or write to the server, you must check if you have a valid handle. If not, you must get a new one.
>
>>Dear Experts
>>
>>I am using SQLSERVER 2008 with VFP.
>>
>>When there is no activity, user on workstation face this error message
>>
>>
>>ConnectionWrite(WrapperWrite(0))
>>
>>As a result connection is lost
>>
>>How to make connection live in case of no activity.
>>
>>Please help
"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