Hi,
I have an app that - for one customer - gets the following error (sometimes):
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send())
I googled for this error but most of what I read on MS sites about this issue goes over my head. My question is, do you think if I "Catch" this error (with Try/Catch) and make the program (VFP9) recreate the connection, will it work?
UPDATE: Another approach I am thinking is that - every time - before the CursorAdapter cursor is filled, check for valid connection (as suggested by Borislav some time ago). Like the following:
IF SQLEXEC( oApp.conn_handle, "SELECT CAST(1 as bit) As Test", "crsTestConnection") < 0
Is this a better approach?
"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