Using the SQL Server Connection Type

How to use the SQL Server connection type

The SQL Server connection type is a protocol used to establish a connection between the form application and a SQL Server database. A SQL Server database is a structured collection of data within a Microsoft SQL Server instance. These databases are widely used in enterprise environments to manage large volumes of structured data, support business applications, and ensure data integrity and security.

1. From the Configuration menu on the left, select Data Connections.
2. Click (Add Connection) to open the Connection window. 
   
3. Enter a connection name and description for the SQL Server connection. This helps you identify the data connection if you connect to more than one database.
4. Select SQL Server as the connection type.
5. Enter a username and password for the SQL Server.
6. Enter the parameters that specifies the information necessary for a client application to connect to a SQL Server database in the Connection String field.
7. Click Test Connection to ensure your settings are correct. 
8. Click Save when you've completed your changes.