To run an application that uses the SQL Connection API,
| 1. | Install and configure SQL Connection. Then, if you plan to use SQL Open Net for the network layer (which is recommended), install and configure SQL OpenNet and start the SQL OpenNet server by following the steps in the installation instructions and Configuring Connectivity Series. SQL OpenNet supports SSL encryption (data packet encryption) and other features. The SQL OpenNet service has a display name of “Synergy/DE OpenNet Server” and a service name of SynSQL. |
| 2. | Initialize SQL Connection. This instructs the Synergy runtime to allocate the necessary memory. |
On Windows and UNIX, there are two ways to do this:
- Call %OPTION from your program and use this function to set system option #48. For information, see Initializing SQL Connection.
- Use the DBLOPT environment variable to set system option #48. You can set DBLOPT in the system environment or (on Windows) in synergy.ini.
On OpenVMS, call %INIT_SSQL from your program. For information, see Initializing SQL Connection.
If you use DBLOPT to set system option #48, all Synergy programs use the extra memory that the Synergy runtime allocates for SQL Connection, even if these programs don’t use SQL Connection. However, if you call %INIT_SSQL or %OPTION from your program, only programs that use SQL Connection will use these extra resources.
