Features and supported databases

SQL Connection features include

Supported databases and operating systems

SQL Connection conforms to ANSI-standard database communication methods SQLCA and SQLDA (ANSI 89) and supports the following databases on the listed platforms.

SQL Connection programs (Synergy programs that make SQL Connection API calls) can run on any platform supported by Synergy, but a database accessed by a SQL Connection program (e.g., when using “net:”) must be on a platform listed below as supported. For information on platforms supported by Synergy, see System Requirements. For information on SQL OpenNet (used when a connection string includes “net:”), see Configuring Connectivity Series and Building connect strings.

Important

MySQL 8 requires OpenSSL 1.1.1 (even if you are not using data packet encryption), so on UNIX, it is supported only on platforms that support that version of OpenSSL. See MySQL notes and examples for additional information.

(For information on supported Windows, UNIX, and OpenVMS platforms, see System Requirements.)

Databases with limited support

SQL Connection has limited support for the following database systems. Support for these databases may require assistance from Synergex Professional Services Group and additional support fees. Contact your Synergex account executive for details.