MSSQL OLEDB plug-in: Difference between revisions

From NSIS Wiki
Jump to navigationJump to search
mNo edit summary
 
mNo edit summary
Line 19: Line 19:
== Functions ==
== Functions ==


=== SQL_Logon ===


<highlight-nsis>MSSQL_OLEDB::SQL_Logon <server> <user> <password></highlight-nsis>
<highlight-nsis>MSSQL_OLEDB::SQL_Logon <server> <user> <password></highlight-nsis>


;Logs on a SQL Server
;Logs on a SQL Server
:<server>       Network name of SQL Server to log on
:<server> - Network name of SQL Server to log on
<user>         User (leave blank to use windows authentication)
:<user> - User (leave blank to use windows authentication)
<password>     Password
:<password> - Password


    Returns:   "0" Success, "1" Failure
;Returns:
                A Message string
:*"0" Success, "1" Failure
:*A Message string
 
=== SQL_Execute ===
                  
                  
SQL_Execute <query>
<highlight-nsis>MSSQL_OLEDB::SQL_Execute <query></highlight-nsis>


    Excecutes a SQL query
;Excecutes a SQL query
    <query> SQL query to execute
:<query> - SQL query to execute
      
      
    Returns:    "0" Success, "1" Failure
;Returns:     
                A message string
:*"0" Success, "1" Failure
:*A message string
                  
                  
SQL_GetRow
=== SQL_GetRow ===


    Retrieves a row of data from the SQL server
<highlight-nsis>MSSQL_OLEDB::SQL_GetRow</highlight-nsis>
 
;Retrieves a row of data from the SQL server
      
      
    Returns:    "0" Success, "1" Failure, "2" No more data to read
;Returns:     
                A string containing the row of data (each column is separated
:*"0" Success, "1" Failure, "2" No more data to read
                by a '|' char). A message in case if error or no more data
:*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
=== SQL_GetError ===
 
<highlight-nsis>MSSQL_OLEDB::SQL_GetError</highlight-nsis>


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


    Returns:   "0" Success
;Returns:
                A string containing the error
:*"0" Success
:*A string containing the error
                  
                  
SQL_Logout
=== SQL_Logout ===
 
<highlight-nsis>MSSQL_OLEDB::SQL_Logout</highlight-nsis>
 
;Deallocates memory used by dll and logs out of SQL server. Use this function WITHOUT the /NOUNLOAD switch when finished using the plugin
 
== Credits ==
Written by Stefano Giusto [sgiusto@mmpoint.it]


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

Revision as of 23:15, 12 March 2007

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

SQL_Logon

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

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

SQL_GetRow

MSSQL_OLEDB::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

MSSQL_OLEDB::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

MSSQL_OLEDB::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

Credits

Written by Stefano Giusto [sgiusto@mmpoint.it]

Retrieved from "https://nsis.sourceforge.io/mediawiki/index.php?title=MSSQL_OLEDB_plug-in&oldid=12107"