Class: MSSQLClient
mssql.MSSQLClient Client is a client for MS SQL database. Internally client uses microsoft/go-mssqldb driver.Example
Table of contents
Constructors
Methods
Constructors
constructor
• new MSSQLClient():MSSQLClient
Returns
MSSQLClient
Defined in
mssql.ts:16Methods
Connect
▸ Connect(host, port, username): boolean
Connect connects to MS SQL database using given credentials.
If connection is successful, it returns true.
If connection is unsuccessful, it returns false and error.
The connection is closed after the function returns.
Parameters
Returns
boolean
Example
Defined in
mssql.ts:29ConnectWithDB
▸ ConnectWithDB(host, port, username): boolean
ConnectWithDB connects to MS SQL database using given credentials and database name.
If connection is successful, it returns true.
If connection is unsuccessful, it returns false and error.
The connection is closed after the function returns.
Parameters
Returns
boolean
Example
Defined in
mssql.ts:46IsMssql
▸ IsMssql(host, port): boolean
IsMssql checks if the given host is running MS SQL database.
If the host is running MS SQL database, it returns true.
If the host is not running MS SQL database, it returns false.
Parameters
Returns
boolean
Example