Preparations

The drivers that are required to use SQL Server database are bundled with the software the software and no additional preparations are required.

Advanced Connection Configuration for SQL Server

If required, you can set the selectMethod when you select the Advanced Connection Setup option.

By default, the selectMethod property on all connections towards the SQL Server type of database is set to cursor.  If required, you can set the property to direct by selecting the Advanced Connection Setup option, and entering a connection string manually. For example, if you require to use direct mode, you can add a connection string that will create connections using selectMode direct, as shown in the image below.

Advanced Connection Setup for SQL Server