We are using CursorAdapters to connect to SQL Server through ADO. I am trying to makes this solution robust enough to handle situations in which the connection to the server is lost. To test this, I open the Enterprise manager and kill the process associated with our app.

What is weird, though, is that the error returned by fox (using aError()) is error number 1435, with the following error message:

"Microsoft OLE DB Provider for SQL
Server : [DBNETLIB][ConnectionWrite (send()).]General network error. See the documentation for the network." (Note: The error message is translated from Norwegian, hence the exact wording may not be the same as in English.)

The rows in the array (returned by aError) for OLE error codes and messages are both .NULL.

So I guess my question is two-fold: Why is error number 1435 (XML parse error) returned, and does anyone have a good method of dealing with situation in which the connection to the SQL Server is lost?

Thanks,

Eyvind.