This section contains information that is specific to the database type SQL Server.
Supported Functions
The SQL Server database can be used with:
...
| Note | ||
|---|---|---|
| ||
For SQL Server, the column type |
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
| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||