SQL Connection sample programs

The Connectivity Series distribution includes sample programs that illustrate the basic structure for an SQL Connection program. (See Writing an SQL Connection program.) These programs are in the connect\synsqlx subdirectory of the main Synergy/DE installation directory.

Tip

On OpenVMS, when linking SQL Connection programs, be sure to use the ssqlrtl.opt link options file (instead of synrtl.opt).

Examples that work with MySQL, Oracle, SQL Server, Sybase, and Synergy databases

These are distributed on all platforms.

Example for MySQL

This example for MySQL is distributed only on Windows and UNIX.

Example for Oracle

This example for Oracle is distributed on all platforms.

Examples for SQL Server

These examples for SQL Server are distributed only on Windows and will run only if the Microsoft pubs sample database is installed. (This legacy sample database is no longer installed with SQL Server by default. See the comments in the files for details.)

Other examples

The Connectivity Series distribution (all platforms) includes exam_saveviews.dbl, an example program for saving views for xfODBC.