Sometimes it can be a problem accessing remote servers from the Internet which does not allows access to control databases but just for your database.
Posts Tagged ‘Connection’
How to Set DataBase Name at Login in Flex2SQL for PostgreSQL and MySQL
Thursday, March 12th, 2009Using Auto-Reconnect in a Cluster Situation
Tuesday, February 24th, 2009For customers who have a full blown cluster just as in database mirroring, typically when testing a failover, there is a hiccup of a few seconds. Our auto-reconnect feature has been able to detect the failover and continue working without problems.
New Command: SQL_ENABLE_RECONNECT
Monday, February 16th, 2009SQL_ENABLE_RECONNECT allows the MySQL Driver to automatically reconnect to the server after the connection has been closed by a time-out. In the MySQL my.ini file you can set a system variable called wait_timeout to set the number of seconds that the server will wait on a non-interactive connection before it closes the connection. The default value for this variable is 28800 (8 hours). See also the MySQL manual under Server System Variables and more specifically the variables wait_timeout and interactive_timeout. (more…)
New Flex2SQL v10.x Feature: Auto-reconnect
Friday, February 13th, 2009If the server is set to time out a client connection due to lack of activity, then a DataFlex program will encounter unexpected errors if the user is not aware of losing connection to the server. With this new feature, the driver will automatically reconnect to the server and continue from the same point where disconnect happened.
New Flex2SQL v10.x Feature: External INI File
Friday, February 13th, 2009Mertech provides a lot of tweaking options (especially in DataFlex) to control the workings of the driver. These have previously only been available through Macro commands, which has meant that to test them out, the application would have to be recompiled.