I have two files. Second file is linked with MySQL by using ODBC driver. Im using script to send data from first file to a second one (ODBC+MySQL). If connection is lost with MySQL server, i will get "ODBC communication/link error" .
Issue, that after this error, file is "locked". All actions are blocked by this error. Even after getting connection back, there is only one way how to get that file up and running - kill FM process and open once more. As i can find, this issue has been reported in version 10 and still there are no solution.
Is it possible to check ODBC connection in script and avoid this error if connection is down?