Parameter

Explanation

Data Source Name*

This is the name of the data source name (DSN) you are configuring.

Database type*

This indicates for which type of database you are configuring this DSN (PostgreSQL).

Description

This field provides a description of the DSN to help distinguish it from others.

Driver*

On the New Data Source Name page, this is the name of the ODBC driver installed for the type of database selected in the Database type box (PostgreSQL). It is a nonconfigurable field.

On the Edit Data Source Name page, this is the absolute path name of the ODBC driver specified for this DSN. It is a configurable field.

ServerName*

This is the IP address of the PostgreSQL database server. If this field is empty, the server is assumed to be running on the local computer.

Port*

This is the port on which the PostgreSQL database server is configured to listen. The default is 5432.

Database*

Because there can be multiple installations of a database running on one computer, each database is given its own name. This parameter indicates the name of the database for which you are configuring this DSN.

User

This is the username required for accessing the database. If the username is not provided when configuring a system DSN, every connection string using this DSN must include the username.

Important Security Note:

To prevent access to a database by unauthorized users in shared Web hosting environments, it is recommended that the username and password be provided in each connection string, rather than in the system DSN.

Password

This is the password required for accessing the database. If the password is not provided when configuring a system DSN, every connection string using the DSN must include the password.

Important Security Note:

To prevent access to a database by unauthorized users in shared Web hosting environments, it is recommended that the username and password be provided in each connection string, rather than in the system DSN.

ReadOnly*

When this option is enabled (the check box is selected), the database returns all record sets as read-only. This parameter is disabled by default.

UseCursorLib

When this option is enabled (the check box is selected), ODBC Manager cursor support overrides ODBC driver cursor support. Use this to enable scrollable cursors not supported by the driver. This parameter is enabled by default.