If you don't use the internal DNS configuration (it is recommended to use it) its important to fine tune your ODBC driver's option.
ILA has an editor to help you configure ILA import utility.
The correct configuration options for a DNS that accesses a MySQL is as follows:
Don't optimize column width |
Return matching rows |
Use compressed protocol |
If you use MySQL ODBC driver 3.51.XX your configuration looks like the next image.
If you use MySQL ODBC driver 2.50.XX your configuration looks like the next image.
If your MySQL server version is 5.00 or newer you have to use MySQL ODBC Driver 3.51.12 or newer to let ILA to work.
Look to for information.