Connection Management¶

Flex2SQL has built-in connection management. The driver will automatically reconnects to the server and continues from the same point where the disconnect occurred.

You can even put a machine to sleep, disconnect it from the network, then bring it back up, and it will not have missed a beat. Customers with Web applications, customers with unreliable connections (especially if they are connecting over the Internet), and customers who leave their applications idling overnight will find this feature useful.

To the end user, there is no visible impact of losing the connection to server in most instances. The only exception to this is in-progress transactions. Any non-committed transactions must be retried by the application.

Three settings in the MERTECH.INI file, AutoReconnect, AutoReconnectDialog, and ConnectionTimeout affect the auto-reconnect feature. The default settings for this feature will work in most cases.