Versions Compared

Old Version 1

changes.mady.by.user Jenni Wallin

Saved on

compared with

New Version 2

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This section contains information that is specific to the database type SQL Server.

 Supported Functions

 The SQL Server database can be used with:

...


Note
titleNote!

For SQL Server, the column type timestamp is not supported in tables accessed by. Use column type datetime instead. See also the /wiki/spaces/MD82/pages/3778529 System Administration Guide for information about time zone settings.


Preparations

The drivers that are required to use SQL Server database are bundled with 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.

Image RemovedImage Added

Advanced Connection Setup for SQL Server