DIALECT=1 - Parser processes as it did in InterBase V5. DIALECT=2 - Transitional flagger. InterBaseV6, and Firebird flags ambiguous SQL constructs and issues an error or warning message. DIALECT=3 - Parser processes anything delimited by single quotes as string constants and any thing delimited by double quotes as SQL delimited identifiers. The driver will quote (') your table names in SQL statements automatically.
We develop affordable, easy to use ODBC drivers for Mac OS X, connecting Excel and FileMaker to Microsoft SQL Server, Oracle, Access, Sybase, MySQL and PostgreSQL. Actual ODBC Driver for Open Source Databases (360) 466-3981 subatom. Actual ODBC Driver for Microsoft Access. Actual ESS Adapter.
DRIVER= Firebird/InterBase(r) driver; UID= SYSDBA; PWD= masterkey; DBNAME= C: database myData.fdb; AUTOQUOTED= YES. DIALECT=1 - Parser processes as it did in InterBase V5.
DIALECT=2 - Transitional flagger. InterBaseV6, and Firebird flags ambiguous SQL constructs and issues an error or warning message. DIALECT=3 - Parser processes anything delimited by single quotes as string constants and any thing delimited by double quotes as SQL delimited identifiers.
![Source Source](http://www.actualtech.com/images/OpenSourceDatabases_snapshot.gif)
The driver will quote (') your table names in SQL statements automatically. DRIVER= Firebird/InterBase(r) driver; UID= SYSDBA; PWD= masterkey; DBNAME= C: database myData.gdb; AUTOQUOTED= YES.