Is accessing Flex2SQL Driver registration information registered on their server, is there any program that can check the liceseing information (such as Licened To:, Number of users:, etc) from the file SQL_DRV.CFG possible?
Flex2SQL will auto generate these files:
In this article we will explain how to create a migration trace to troubleshot problems:
In using Flex2SQL for record transfer, it stops without any apparent errors before completion. The problem was due to the DATE_ACQ field, more specifically the value of a leap year (for example, 2-29-1900). DataFlex does not care about leap years, but other databases do. The problem is solved by modifying the errant dates.
The DataFlex date format isn’t compatible with MS SQL. You must to change the way as argument is passed and/or is received.
Take a look at this sample program. You may see that the variable is declared as a string, but should be date. I’m changing the date format before call stored procedure: