>>Hi,
>>
>>I received an error message from the customer using VFP 9 app with SQL Server 2005. The error message says "[ODBC SQL Server Driver] Communication link failure."
>>
>>Does anybody know what could cause such error? What to do to prevent it? TIA.
>
>The connection to the SQL Server is lost.
>You can't prevent this, but you may try to reconnect.
>This could be caused by bad LAN card, torn cable, bad switch etc. No power for some LAN devices.
Thank you. I will have to think of how to make the "reconnect" work anywhere in my application. I never thought about this during the design phase.
"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