Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sqlserver timeout
Message
From
23/09/2016 16:45:28
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 7
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01641240
Message ID:
01641284
Views:
48
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform