Unicode Edition¶
Flex2SQL Unicode Edition v17.1.9897.0¶
Flex2SQL Unicode Edition v17.1.9897.0 was released on 2023-10-31.
The Unicode Editions drivers are supported on:
Windows 10 and up
Windows Server 2016 and up
Note
The operating system of the database server doesn’t affect compatibility. Unicode Edition drivers have been tested on DataFlex 2021 and DataFlex 2023.
Server versions supported
Azure SQL Database
SQL Server 2022
SQL Server 2019
SQL Server 2017
SQL Server 2016
SQL Server 2014
The Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is required. You should download based on the bitness of your Windows installation. So a 32-bit version of Windows needs the 32-bit install while a 64-bit version of Windows needs the 64-bit install. This is independent of the bitness of your application. The advised version to use is 19.3.1. The older Microsoft SQL Server 2012 Native client (SQLNCLI) should no longer be used.
Note
All editions of SQL Server are supported including SQL Server for Linux. Both 64-bit and 32-bit releases are available for Flex2SQL Unicode Edition for MS SQL.
Server versions supported
Autonomous Database
Base Database
Oracle Database 23c
Oracle Database 21c
Oracle Database 19c
Oracle Database 18c
Oracle Database 12c Release 2
An Oracle Client is required. The Oracle Client’s bitness must match the bitness of your application. This means that 32-bit compiled applications must use a 32-bit Oracle Client and 64-bit compiled applications must use a 64-bit Oracle Client. The Deployment Tool can be used to install a self-contained Oracle Instance Client or a client can be downloaded directly from Oracle’s website.
Note
Oracle Database cloud testing is done using OCI. Both 64-bit and 32-bit releases are available for Flex2SQL Unicode Edition for Oracle.
Server versions supported
Azure Database for PostgreSQL
Amazon RDS for PostgreSQL
Amazon Aurora PostgreSQL
PostgreSQL 16.x
PostgreSQL 15
PostgreSQL 14
PostgreSQL 13
PostgreSQL 12
Note
Flex2SQL Unicode Edition for PostgreSQL is available only as a 64-bit release.
Server versions supported
Azure Database for MySQL
Amazon RDS for MySQL
Amazon Aurora MySQL
MySQL 8.0.33
MySQL 8.0.x
Note
Flex2SQL Unicode Edition for MySQL is available only as a 64-bit release. Flex2SQL requires the log_bin_trust_function_creators setting to be TRUE. ERROR_FOR_DIVISION_BY_ZERO and NO_ENGINE_SUBSTITUTION also need to be in the list of SQL modes (in versions >8.0 they are in the list by default).
Server versions supported
Azure Database for MariaDB
Amazon RDS for MariaDB
MariaDB 11.0.2
MariaDB 10.x.x
Note
Flex2SQL Unicode Edition for MariaDB is available only as a 64-bit release.
Flex2SQL Unicode Edition v17.1.9785.0¶
Flex2SQL Unicode Edition v17.1.9785.0 was released on 2023-07-06.
The Unicode Editions drivers are supported on:
Windows 10 and up
Windows Server 2016 and up
Note
The operating system of the database server doesn’t affect compatibility. Unicode Edition drivers have been tested on DataFlex 2021 and DataFlex 2023.
Server versions supported
Azure SQL Database
SQL Server 2022
SQL Server 2019
SQL Server 2017
SQL Server 2016
SQL Server 2014
The Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is required. You should download based on the bitness of your Windows installation. So a 32-bit version of Windows needs the 32-bit install while a 64-bit version of Windows needs the 64-bit install. This is independent of the bitness of your application. The advised version to use is 19.3.1. The older Microsoft SQL Server 2012 Native client (SQLNCLI) should no longer be used.
Note
All editions of SQL Server are supported including SQL Server for Linux. Both 64-bit and 32-bit releases are available for Flex2SQL Unicode Edition for MS SQL.
Server versions supported
Autonomous Database
Base Database
Oracle Database 23c
Oracle Database 21c
Oracle Database 19c
Oracle Database 18c
Oracle Database 12c Release 2
An Oracle Client is required. The Oracle Client’s bitness must match the bitness of your application. This means that 32-bit compiled applications must use a 32-bit Oracle Client and 64-bit compiled applications must use a 64-bit Oracle Client. The Deployment Tool can be used to install a self-contained Oracle Instance Client or a client can be downloaded directly from Oracle’s website.
Note
Oracle Database cloud testing is done using OCI. Both 64-bit and 32-bit releases are available for Flex2SQL Unicode Edition for Oracle.
Server versions supported
Azure Database for PostgreSQL
Amazon RDS for PostgreSQL
Amazon Aurora PostgreSQL
PostgreSQL 15.x
PostgreSQL 14
PostgreSQL 13
PostgreSQL 12
Note
Flex2SQL Unicode Edition for PostgreSQL is available only as a 64-bit release.
Server versions supported
Azure Database for MySQL
Amazon RDS for MySQL
Amazon Aurora MySQL
MySQL 8.0.33
MySQL 8.0.x
Note
Flex2SQL Unicode Edition for MySQL is available only as a 64-bit release. Flex2SQL requires the log_bin_trust_function_creators setting to be TRUE. ERROR_FOR_DIVISION_BY_ZERO and NO_ENGINE_SUBSTITUTION also need to be in the list of SQL modes (in versions >8.0 they are in the list by default).
Server versions supported
Azure Database for MariaDB
Amazon RDS for MariaDB
MariaDB 11.0.2
MariaDB 10.x.x
Note
Flex2SQL Unicode Edition for MariaDB is available only as a 64-bit release.
Flex2SQL Unicode Edition v17.0.9622.0¶
Flex2SQL Unicode Edition v17.0.9622.0 was released on 2023-02-06.
The Unicode Editions drivers are supported on:
Windows 10 and up
Windows Server 2016 and up
Note
The operating system of the database server doesn’t affect compatibility. Unicode Edition drivers have been tested on DataFlex 20 and DataFlex 2021.
Server versions supported
Azure SQL Database
SQL Server 2022
SQL Server 2019
SQL Server 2017
SQL Server 2016
SQL Server 2014
The Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is required. You should download based on the bitness of your Windows installation. So a 32-bit version of Windows needs the 32-bit install while a 64-bit version of Windows needs the 64-bit install. This is independent of the bitness of your application. The advised version to use is 19.0. The older Microsoft SQL Server 2012 Native client (SQLNCLI) should no longer be used.
Note
All editions of SQL Server are supported including SQL Server for Linux. Both 64-bit and 32-bit releases are available for Flex2SQL Unicode Edition for MS SQL.
Server versions supported
Autonomous Database
Base Database
Oracle Database 21c
Oracle Database 19c
Oracle Database 18c
Oracle Database 12c Release 2
An Oracle Client is required. The Oracle Client’s bitness must match the bitness of your application. This means that 32-bit compiled applications must use a 32-bit Oracle Client and 64-bit compiled applications must use a 64-bit Oracle Client. The Deployment Tool can be used to install a self-contained Oracle Instance Client or a client can be downloaded directly from Oracle’s website.
Note
Oracle Database cloud testing is done using OCI. Both 64-bit and 32-bit releases are available for Flex2SQL Unicode Edition for Oracle.
Server versions supported
Azure Database for PostgreSQL
Amazon RDS for PostgreSQL
Amazon Aurora PostgreSQL
PostgreSQL 15.x
PostgreSQL 14
PostgreSQL 13
PostgreSQL 12
Note
Flex2SQL Unicode Edition for PostgreSQL is available only as a 64-bit release.
Server versions supported
Azure Database for MySQL
Amazon RDS for MySQL
Amazon Aurora MySQL
MySQL 8.0.33
MySQL 8.0.x
MariaDB 10.x.x
Note
Flex2SQL Unicode Edition for MySQL is available only as a 64-bit release. Flex2SQL requires the log_bin_trust_function_creators setting to be TRUE. ERROR_FOR_DIVISION_BY_ZERO and NO_ENGINE_SUBSTITUTION also need to be in the list of SQL modes (in versions >8.0 they are in the list by default).
Note
Flex2SQL Unicode Edition for MariaDB is available only as a 64-bit release.