The Mssql data source enables interaction with Microsoft SQL Server. With this data source, app developers can access databases, execute queries and integrate data into their apps.
You can establish the connection using the connection parameters, such as host, port, and login information (user and password). You can then use SQL queries to retrieve, insert, update, or delete data.
Things to know
You can only connect to Microsoft SQL Server with versions that are officially supported by Microsoft.
For detailed information see SQL Server Version Certified Compatibility Matrix at:
https://learn.microsoft.com/en-us/sql/connect/php/microsoft-php-drivers-for-sql-server-support-matrix
Parameters
|
Type |
Name |
Description |
|---|---|---|
|
TEXT |
host |
Specifies the server address of the server with SQL Server. |
|
NUMBER |
port |
Specifies the port to which SQL Server listens on the server. |
|
TEXT |
user |
Specifies the user to establish the connection. |
|
PASSWORD |
password |
Specifies the password of the specified user. |
|
TEXT |
database |
Specifies the database that is selected when the connection is established. |