Check
Reconnect a remote view to SQL server Message #
1134304>
>I occasionally have my app crashed due to invalid DB connection.
>
>Is there some ODBC parameters that I should set to prevent connection dropping?
>
>Is there any way to trap this error and reestablish the DB connection automatically when the connection is invalid for some reason.
>
--sb--