SQL parameters: sqllibrary

Startup parameters change the behavior of the Service Manager server. You can always set a startup parameter from the server's operating system command prompt.

Parameter

sqllibrary

Description

This parameter defines the file name of the library containing your RDBMS drivers. Service Manager provides a collection of database drivers for supported vendors and versions.

Valid if set from

Initialization file (sm.ini)

Requires restart of the Service Manager server?

Yes

Default value

One of the following RDBMS drivers:

Oracle

  • Windows – SQORACLE.OCI10.DLL
  • Linux – sqoracle.oci11.so, sqoracle.oci12.so

Microsoft SQL Server

  • Windows – SQMSSQL.ODBC.DLL

Possible values

File name of library containing RDBMS drivers:

Note Driver names are case sensitive. Be sure to use the correct case.

Windows drivers

  • SQDB2.CLI.DLL
  • SQMSSQL.ODBC.DLL
  • SQORACLE.OCI10.DLL

Linux drivers

  • sqdb2.cli.so
  • sqoracle.oci11.so
  • sqoracle.oci12.so

Example usage

If you are running on the Linux system and have oracle11 client software, the initialization file entry is as follows:

-sqllibrary:sqoracle.oci11.so

Related topics

System parameters
Enter a parameter in the sm.ini file
Database parameters