Tested configurations and recommended settings for using external databases.

DBMSDBMS versionODBC driver vendorODBC driver versionRecommended changes of ODBC data source configuration (relatively default)
Microsoft AccessAccess 2003 (11.6355.8107) SP1Microsoft Corporation4.00.6304.00'ExtendedAnsiSQL'=1
Microsoft AccessAccess 2007Microsoft Corporation12.00.4518.1014'ExtendedAnsiSQL'=1
Microsoft SQL ServerMicrosoft SQL Server 2000 Enterprise Edition (8.00.194)Microsoft Corporation2000.85.1117.00-
Microsoft SQL ServerMicrosoft SQL Server 2005 Express Edition (9.00.1399.06)Microsoft Corporation2005.90.1399.00-
OracleOracle 9i Enterprise Edition (9.2.0.1.0)Oracle Corporation9.02.00.80-
OracleOracle Database 10g Express Edition (Western European)Oracle Corporation10.02.00.01-
OracleOracle Database 10g Express Edition (Universal)Oracle Corporation10.02.00.01Database administrator must execute the statement:
ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=CHAR SCOPE=BOTH
MySQLMySQL 5.0.27 community-ntMySQL AB3.51.21.00'Enable auto_increment NULL search' = ON
'Pad Char To Full Length' = ON
'Return Table Names For SQLDescribeCol' = ON
If you use specific code page:
'initial Statement' = 'SET CHARACTER SET <CODE_PAGE_ID>', e.g. 'initial Statement' = 'SET CHARACTER SET cp1251'
MySQLMySQL 5.6.10 community-ntOracle Corporation5.02.04.00Pad CHAR to full length with space = ON
If you use specific code page:
Character set = <CODE_PAGE_ID>, e.g. Character set = cp1251
PostgreSQLPostgreSQL 8.3.0PostgreSQL Global Development Group8.03.01.00'Use Declare/Fetch' = ON
'Server side prepare' = ON
InterBaseInterBase WI-06.0.1.6IBPhoenix Inc2.00.00.142'Character Set' — the same as the database character set.
'Dialect' = 3
'Quoted Identifier' = ON
'Sensitive Identifier' = ON
Recommended page size at creating new database ≥ 8Kb
FirebirdFirebird-2.0.3.12981-1IBPhoenix Inc2.00.00.142'Character Set' — the same as the database character set.
'Dialect' = 3
'Quoted Identifier' = ON
'Sensitive Identifier' = ON
Recommended page size at creating new database ≥ 8Kb
DB2IBM DB2 Express-C 9.5.0.808IBM9.5.0.808'LongDataCompat' = 1 (as LONGVAR data)