Classic Edition¶
Flex2SQL Classic Edition v17.1.9897.0¶
Flex2SQL Classic Edition v17.1.9897.0 was released on 2023-10-31.
The Classic Editions drivers are supported the following operating systems:
Windows 8 and up
Windows Server 2014 and up
Ubuntu 18.04 and up
RHEL 8.0 and up
CentOS 8 and up
DataFlex versions supported:
DataFlex on Linux 3.1c and up
Console Mode DataFlex 3.1c and up for Windows
DataFlex 7 - DataFlex 19.1
Note
The operating system of the database server doesn’t affect compatibility. Classic Edition drivers are not supported in the Unicode and 64-bit releases of DataFlex.
Server versions supported
Azure SQL Database
SQL Server 2022
SQL Server 2019
SQL Server 2017
SQL Server 2016
SQL Server 2014
SQL Server 2012
The Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is required. The advised version to use is 19.3.1. 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 older Microsoft SQL Server 2012 Native client (SQLNCLI) should no longer be used.
Note
There is no MS SQL drivers available for Linux, this driver can only be used on Windows. All editions of SQL Server are supported including SQL Server for Linux.
Server versions supported
Autonomous Database
Base Database
Oracle Database 23c
Oracle Database 21c
Oracle Database 19c
Oracle Database 18c
Oracle Database 12c
Oracle Database 11g
An Oracle Client is required. The Oracle Client’s bitness must match the bitness of your application. This means you must use a 32-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.
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
PostgreSQL 11
PostgreSQL 10
PostgreSQL 9.6
Server versions supported
Azure Database for MySQL
Amazon RDS for MySQL
Amazon Aurora MySQL
MySQL 8.0.33
MySQL 5.7
Note
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
Flex2SQL Classic Edition v17.1.9784.0¶
Flex2SQL Classic Edition v17.1.9784.0 was released on 2023-07-06.
The Classic Editions drivers are supported the following operating systems:
Windows 8 and up
Windows Server 2014 and up
Ubuntu 18.04 and up
RHEL 8.0 and up
CentOS 8 and up
DataFlex versions supported:
DataFlex on Linux 3.1c and up
Console Mode DataFlex 3.1c and up for Windows
DataFlex 7 - DataFlex 19.1
Note
The operating system of the database server doesn’t affect compatibility. Classic Edition drivers are not supported in the Unicode and 64-bit releases of DataFlex.
Server versions supported
Azure SQL Database
SQL Server 2022
SQL Server 2019
SQL Server 2017
SQL Server 2016
SQL Server 2014
SQL Server 2012
The Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is required. The advised version to use is 19.3.1. 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 older Microsoft SQL Server 2012 Native client (SQLNCLI) should no longer be used.
Note
There is no MS SQL drivers available for Linux, this driver can only be used on Windows. All editions of SQL Server are supported including SQL Server for Linux.
Server versions supported
Autonomous Database
Base Database
Oracle Database 23c
Oracle Database 21c
Oracle Database 19c
Oracle Database 18c
Oracle Database 12c
Oracle Database 11g
An Oracle Client is required. The Oracle Client’s bitness must match the bitness of your application. This means you must use a 32-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.
Server versions supported
Azure Database for PostgreSQL
Amazon RDS for PostgreSQL
Amazon Aurora PostgreSQL
PostgreSQL 15.x
PostgreSQL 14
PostgreSQL 13
PostgreSQL 12
PostgreSQL 11
PostgreSQL 10
PostgreSQL 9.6
Server versions supported
Azure Database for MySQL
Amazon RDS for MySQL
Amazon Aurora MySQL
MySQL 8.0.33
MySQL 5.7
Note
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
Flex2SQL Classic Edition v17.0.9622.0¶
Flex2SQL Classic Edition v17.0.9622.0 was released on 2023-02-06.
The Classic Editions drivers are supported the following operating systems:
Windows 7 and up
Windows Server 2014 and up
Ubuntu 18.04 and up
RHEL 8.0 and up
CentOS 8 and up
DataFlex versions supported:
DataFlex on Linux 3.1c and up
Console Mode DataFlex 3.1c and up for Windows
DataFlex 7 - DataFlex 19.1
Note
The operating system of the database server doesn’t affect compatibility. Classic Edition drivers are not supported in the Unicode and 64-bit releases of DataFlex.
Server versions supported
Azure SQL Database
SQL Server 2022
SQL Server 2019
SQL Server 2017
SQL Server 2016
SQL Server 2014
SQL Server 2012
The Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is required. The advised version to use is 19.0. 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 older Microsoft SQL Server 2012 Native client (SQLNCLI) should no longer be used.
Note
There is no MS SQL drivers available for Linux, this driver can only be used on Windows. All editions of SQL Server are supported including SQL Server for Linux.
Server versions supported
Autonomous Database
Base Database
Oracle Database 21c
Oracle Database 19c
Oracle Database 18c
Oracle Database 12c
Oracle Database 11g
An Oracle Client is required. The Oracle Client’s bitness must match the bitness of your application. This means you must use a 32-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.
Server versions supported
Azure Database for PostgreSQL
Amazon RDS for PostgreSQL
Amazon Aurora PostgreSQL
PostgreSQL 15.3
PostgreSQL 14
PostgreSQL 13
PostgreSQL 12
PostgreSQL 11
PostgreSQL 10
PostgreSQL 9.6
Server versions supported
Azure Database for MySQL/MariaDB
Amazon RDS for MySQL/MariaDB
Amazon Aurora MySQL/MariaDB
MySQL 8.0.33 / MariaDB 10.x
MySQL 5.7 / MariaDB 5.7
Note
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).