SQL_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…)
Archive for February, 2009
New Command: SQL_ENABLE_RECONNECT
Monday, February 16th, 2009New Command: SET_SESSION_PARAMETER
Monday, February 16th, 2009SET_SESSION_PARAMETER OEM_TRANSLATION_STATE allows users to programmatically enable or disable OEM to ANSI translation. Once enabled, this affects all data files used by the application. This is equivalent to adding “TRANSLATE_OEM_TO_ANSI 1″ in the INT file. SET_SESSION_PARAMETER OEM_TRANSLATION_STATE can be called at any time.
Write Your Own Migration Routines Using the CONVERT_DAT_FILE Macro
Monday, February 16th, 2009Mertech provides a macro, CONVERT_DAT_FILE that can be called from a DataFlex program using the Mertech.inc file. This macro will migrate a DataFlex file to the target backend, creating table and index structures and copying data using the default settings of GUI database migration tool.
Using the COPY_DATA Feature With Flex2SQL
Friday, February 13th, 2009The COPY_DATA feature allows the user to copy data from an SQL table to a DAT file and vice versa.
Flex2SQL has two options that allows us to copy the data from a DAT to a SQL and vice versa, but our customers prefer a single command approach.
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.