Mensaje
De
14/10/2016 09:56:55
a
14/10/2016 09:53:51
Miscellaneous
ID de la conversación:
01641919
ID del mensaje:
01641959
Views:
29
>>Hi,
>>
>>Does the error [ODBC SQL Server Driver] Communication Link Failure produced in VFP application mean that the SQL Server connection handle was timed out? Or there is another reason for it?
>>
>>TIA
>
>It means that you lost connection to the server. From a problem in the NIC to a overloaded server, there is a wide spectrum of reasons that may trigger it.
>
>After the error, are you able to reuse the handle, or do you have to SQLCONNECT() again?
Yes, I tracked a case yesterday where, after the Communication Link Failure, the application reconnected to the server. But then, just a few seconds (or maybe even milliseconds) later that error happens again. But this time in Tableupdate() of Cursor Adapter cursor.
>>
>>Does the error [ODBC SQL Server Driver] Communication Link Failure produced in VFP application mean that the SQL Server connection handle was timed out? Or there is another reason for it?
>>
>>TIA
>
>It means that you lost connection to the server. From a problem in the NIC to a overloaded server, there is a wide spectrum of reasons that may trigger it.
>
>After the error, are you able to reuse the handle, or do you have to SQLCONNECT() again?
Yes, I tracked a case yesterday where, after the Communication Link Failure, the application reconnected to the server. But then, just a few seconds (or maybe even milliseconds) later that error happens again. But this time in Tableupdate() of Cursor Adapter cursor.
"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