Using the SQL Run-Time Functions in InstallScript and InstallScript MSI Projects

InstallShield 2016

Project • This information applies to the following project types:

The InstallScript language includes many built-in SQL run-time (SQLRT) functions that begin with a prefix of SQLRT. Some of the functions are available only in InstallScript projects, some are available only in InstallScript MSI projects, and some are available in both project types.

The SQLRT functions require that you configure SQL information through the SQL Scripts view; the configuration information is written to the SQLRT.ini file so that the SQL run-time functions work properly. For InstallScript projects, the SQLRT functions are in the SQLRT.obl file, and they call the SQLRT.dll file. For InstallScript MSI projects, the SQLRT functions are in the SQLCONV.obl file, and they call the ISSQLSRV.dll file. These support files are added automatically to your project when you use the SQL Scripts view.

The SQLRTInitialize2 function initializes the SQL server run time. In InstallScript projects, the SQLRTInitialize2 function is called automatically during the OnSQLServerInitialize event handler. In InstallScript MSI projects, the SQLRTInitialize2 function is called automatically during the OnSQLLogin event handler. If you need to call one of the SQLRT functions before the OnSQLServerInitialize or OnSQLLogin events, you must first call the SQLRTInitialize2 function.

Note • In earlier versions of InstallShield, the SQLRTInitialize function was used to initialize the SQL server run time in InstallScript projects. This function has been superseded by the SQLRTInitialize2 function.

See Also

SQL Functions

SQLRTInitialize2

OnSQLServerInitialize

OnSQLLogin

Open topic with navigation