Previous Topic

Next Topic

Book Contents

Book Index

MySQL Troubleshooting

Configuring MySQL external DSN

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.

mysql_odbc_351

If you use MySQL ODBC driver 2.50.XX your configuration looks like the next image.

mysql_odbc_250

MySQL Server version 5.00 or newer

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.