Page Comparison

Name

Type

Required

Description

id

string

yes

Unique identifier

dbtype

'sqlserver'

yes

The name of the driver to use, in this case sqlserver

host

string

yes

The hostname or ip address of the SQL Server server

port

number

yes

The port number that the SQL Server instance is running on

database

string

no

The database to be connected to

instance

string

no

The SQLServer instance to be connected to

schema

string

no

The schema used when connecting to the database

user

string

yes

The userid used when connecting to the database

passwd

string

yes

The password used when connecting to the database

namespace

string

no

The namespace prefix

minconnections

integer

no

The minimum number of connections to open to the database, default pooled connection. Default 1

maxconnections

integer

no

The maximum number of connections to open to the database, default open connections. Default 10

validateconnections

boolean

no

Should database connections be checked on each access to see if they're still valid, default false

namespace

string

no

The namespace prefix

Check connection is alive before using it. Default false

fetchsize

integer

no

The number of records read with each iteraction with the dbms, default . Default 1000

connectiontimeout

integer

no

The number of seconds the connection pool will wait before timing out attempting to get a new connection, default . Default 20 (seconds)

primarykeymetadatatable

string

no

The optional table containing primary key structure and sequence associations. Can be expressed as 'schema.name' or just 'name'. Default none

maxopenpreparedstatements

integer

no

Maximum number of prepared statements kept open and cached for each connection in the pool. Set to 0 to have unbounded caching, to -1 to disable caching. Default 50