Access Relational Databases

SQL Connection is a direct Structured Query Language (SQL) API that enables you to write database-independent, SQL-based applications that access data in a variety of Relational Database Management Systems (RDBMSs).

SQL Connection Features

  • Ability to access relational databases, such as Oracle and SQL Server, from Synergy applications.
  • Ability to combine, compare, calculate, store, transact, commit, rollback, and perform all other standard SQL functions.
  • Conformance with ANSI-standard database communication methods: SQLCA and SQLDA (ANSI 89).
  • Example programs that demonstrate how to use the SQL Connection functions.
  • Extensive error reporting and operation logging.
  • Optimized data access with features such as the ability to reuse cursors, built-in statement caching, stored procedures, and SQL prefetching.
  • Database independence—the same Synergy code can access multiple databases.
  • Automatic data-type conversion.
  • Binding of Synergy DBL variables with database variables.
  • Ability to open up to seven concurrent database channels, multiple databases simultaneously, and the same database more than once in an application.
  • Ability to configure network communication with username and password encryption, settings to adjust network traffic, read and write timeouts, and communication port number setting.
  • Access to local or remote data on Windows, Linux/Unix, and OpenVMS systems.

SQL Connection fully supports access to the following database systems:

  • Synergy DBMS
  • Oracle®
  • Microsoft® SQL Server
  • MySQL

Support for the following databases may require assistance from Synergex Professional Services:

  • Oracle Rdb
  • Sybase®
  • Informix®
  • ODBC-compliant databases