I don't use any CA myself, hopefully someone else can jump in?
>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