Tested configurations and recommended settings for using external databases.
 | |
| DBMS | DBMS version | ODBC driver vendor | ODBC driver version | Recommended changes of ODBC data source configuration (relatively default) |
| Microsoft Access | Access 2003 (11.6355.8107) SP1 | Microsoft Corporation | 4.00.6304.00 | 'ExtendedAnsiSQL'=1 |
| Microsoft Access | Access 2007 | Microsoft Corporation | 12.00.4518.1014 | 'ExtendedAnsiSQL'=1 |
| Microsoft SQL Server | Microsoft SQL Server 2000 Enterprise Edition (8.00.194) | Microsoft Corporation | 2000.85.1117.00 | - |
| Microsoft SQL Server | Microsoft SQL Server 2005 Express Edition (9.00.1399.06) | Microsoft Corporation | 2005.90.1399.00 | - |
| Oracle | Oracle 9i Enterprise Edition (9.2.0.1.0) | Oracle Corporation | 9.02.00.80 | - |
| Oracle | Oracle Database 10g Express Edition (Western European) | Oracle Corporation | 10.02.00.01 | - |
| Oracle | Oracle Database 10g Express Edition (Universal) | Oracle Corporation | 10.02.00.01 | Database administrator must execute the statement:
ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=CHAR SCOPE=BOTH |
| MySQL | MySQL 5.0.27 community-nt | MySQL AB | 3.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' |
| MySQL | MySQL 5.6.10 community-nt | Oracle Corporation | 5.02.04.00 | Pad CHAR to full length with space = ON
If you use specific code page:
Character set = <CODE_PAGE_ID>, e.g. Character set = cp1251
|
| PostgreSQL | PostgreSQL 8.3.0 | PostgreSQL Global Development Group | 8.03.01.00 | 'Use Declare/Fetch' = ON
'Server side prepare' = ON |
| InterBase | InterBase WI-06.0.1.6 | IBPhoenix Inc | 2.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 |
| Firebird | Firebird-2.0.3.12981-1 | IBPhoenix Inc | 2.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 |
| DB2 | IBM DB2 Express-C 9.5.0.808 | IBM | 9.5.0.808 | 'LongDataCompat' = 1 (as LONGVAR data) |
