Message
From
23/09/2016 17:49:34
To
23/09/2016 16:45:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 7
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01641240
Message ID:
01641286
Views:
44
Thank you for your reply. I do get an error, just like Tariq, that connection was lost. Usually happens when user "sits" on a screen and updates (clicks on Save) after a long period. We will see if anybody can make a suggestion.
Have a great weekend.
>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
Have a great weekend.
>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
"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
"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