MSSQL OLEDB plug-in

Author: sgiusto@mmpoint.it (talk, contrib)

Download

MSSQL_OLEDB.zip (73 KB)

Description

The MSSQL OLEDB plugin for NSIS provides some functions to add MSSQL interoperability within an install script

Version: 12th March 2007.
Supported on: Windows NT, Windows 2000, Windows XP.

Notes

All functions must be called with the /NOUNLOAD switch Only SQL_Logout must be called as last and without /NOUNLOAD

Functions

MSSQL_OLEDB::SQL_Logon <server> <user> <password>

Logs on a SQL Server

<server> Network name of SQL Server to log on

<user> User (leave blank to use windows authentication) <password> Password

   Returns:    "0" Success, "1" Failure
               A Message string
               

SQL_Execute <query>

   Excecutes a SQL query
   <query> SQL query to execute
   
   Returns:    "0" Success, "1" Failure
               A message string
               

SQL_GetRow

   Retrieves a row of data from the SQL server
   
   Returns:    "0" Success, "1" Failure, "2" No more data to read
               A string containing the row of data (each column is separated
               by a '|' char). A message in case if error or no more data
               

SQL_GetError

   Retrieves last error message generated by SQL Server
   Call this function after a failure to get SQL state, native error code and message

   Returns:    "0" Success
               A string containing the error
               

SQL_Logout

   Deallocates memory used by dll and logs out of SQL server
   Use this function WITHOUT the /NOUNLOAD switch when finished using the plugin