Description 

Enter a description for the database. 

A valid string. The default is SQLServer Connection Pool Datasource.

ServerName 

Specifies the host name of the external database server. 

Any valid string. 

PortNumber 

Specifies the I/O port number on which the server is listening for connection requests. 

A valid port number. The default is 1433. 

DatabaseName 

Specifies the name of the database instance used on the Server. 

Any valid string. 

User 

Specifies the user name that the Adapter uses to connect to the database. 

Any valid string. 

Password 

Specifies the password used to access the database. 

Any valid string. 

DriverProperties

The DataSource implementation may need to execute additional methods to assure a successful run. The additional methods will need to be identified in the Driver Properties. 

The delimiter set by the user. For more information, see the Delimiter property below. 

Valid delimiters are: 

“<method-name-1>#<param-1>#<param-2>

#.........<param-n>##<method-name-2>#<param-1>

#<param-2>#........<param-n>##......##”.

For example: to execute the method setSpyAttributes, give the method a String for the URL “setSpyAttribute#<url>##”. 

The setSpyAttributes (for Data Direct drivers) that are contained in the following examples (between the last set of double octothorps [##] within each example), are used for debugging purposes and need not be used on every occasion.

Optional—if you are using Spy Log: 

“setURL#jdbc:Seebeyond:SQLServer://<server>:4100;”

DatabaseName=<database>##setSpyAttributes#log=

(file)c:/temp/spy.log;logTName=yes##

Delimiter 

This is the delimiter character to be used in the DriverProperties prompt. 

The default is #. See the DriverProperties property above for more information on how the default value is used.

MinPoolSize

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed. 

If the pool size is too small, you may experience longer connection times due to the existing number of physical connections. 

A connection that stays in the pool allows transactions to use it via a logical connection which is faster. 

A valid numeric value. The default is 0.

MaxPoolSize

Specifies the maximum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there is no maximum. 

The pool size depends on the transaction volume and response time. If the pool size is too big, you may end up with too many connections with the database. 

A valid numeric value. The default is 10.

MaxIdleTime 

The maximum number of seconds that a physical connection may remain unused before it is closed. 0 (zero) indicates that there is no limit. 

A valid numeric value.