Using connection properties

You can use connection properties to customize the driver for your environment. You can use these connection properties with either the JDBC DriverManager or a JDBC data source. For a DriverManager connection, a property is expressed as a key value pair and takes the form property=value. For a data source connection, a property is expressed as a JDBC method and takes the form setProperty(value). For a complete list of supported properties, refer to "Connection Property Descriptions" in the Progress DataDirect for JDBC for SQL Server Driver User's Guide

The following table summarizes the minimum connection properties required to connect to a database. For a list of properties that affect performance, see "Tuning for Performance."

Note: All connection property names are case-insensitive. For example, Password is the same as password. Required properties are noted as such.

Table 1. Required Properties
Property	Characteristic
PortNumber	Specifies the TCP port of the primary database server that is listening for connections to the database. The default is 1433.
ServerName	Specifies the name or IP address of the server to which you want to connect.