ODBC Link - ANSI standard SQL syntax

The application uses ANSI-standard SQL syntax for retrieving data from a database via ODBC. Your database must recognise this syntax, otherwise the Link/Import will fail.

Most databases (for example Microsoft Access, Microsoft Excel, SQL Server and Oracle) are ANSI-compliant by default.

MySQL does not support ANSI-standard SQL syntax as the default. It can be enabled however, by entering the following 2 commands in the MySQL command line client:

mysql> SET GLOBAL sql_mode='ANSI';

mysql> SELECT @@global.sql_mode;

Once these 2 commands are run, the ODBC Link/Import operation should work.

ANSI mode can be enabled at all times by changing the start-up options for the database service. For more information, refer to the MySQL online help.