Features and supported databases
SQL Connection features include
- record-oriented or column-oriented bulk data access.
- built-in statement caching and SQL prefetch caching.
- automatic data type conversion and binding of Synergy DBL variables with data.
- independence from Synergy DBL file I/O operations.
- support for up to seven concurrent database connections per program on UNIX and OpenVMS, and up to 100 concurrent connections per program on Windows (for multi-threading). You can open multiple databases simultaneously, and you can open the same database more than once in an application (under the same username or under a different username).
- SSL encryption (data packet encryption) when using SQL OpenNet (see Using data packet encryption for SQL OpenNet).
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.
- MySQL (version 5.1 and higher) on supported Windows, Linux, and AIX platforms.
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. |
- Oracle® (version 11 and higher) on all supported Windows and UNIX platforms. SQL Connection has limited support for Oracle 11 and higher on OpenVMS.
- SQL Server accessed via Microsoft ODBC Driver 17.x for SQL Server. For information on SQL Server versions supported by these drivers, see the Microsoft documentation. For more information on SQL Connection support for Microsoft ODBC drivers, see SQL Server notes and examples.
- Synergy DBMS (version 11.1.1 and higher) on all supported Windows, UNIX, and OpenVMS platforms
(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.
- IBM DB2®
- Informix® on UNIX
- ODBC-compliant databases on Windows
- Oracle Rdb on OpenVMS
- PostgreSQL on Windows
- Sybase® on Windows and UNIX