There are legacy or custom ODBC drivers with non-standard SQL syntax. Our software supports syntax mapping for ODBC connections. This function allows users to replace some SQL keywords to another.

For example, your data source requires QUIRY keyword instead of standard SELECT.

The syntax mapping uses text file with predefined name "syntax.map". It should be located in the same directory as the software binary files (executable and DLLs).

It contains one line per map^*:
SELECT=QUERY

^* - ';' at the begin of the line means comment, extra spaces about '=' are not acceptable.