Parameter

Explanation

Data Source Name*

This is the name of the data source name (DSN) you are configuring. It must match the entry for SQLnkDSN (below), which is the DSN created with the ./setsqllnk utility. For more information, see "Configuring SequeLink" in this chapter.

Database type

On the New Data Source Name page, select SequeLink 4.51a from the list to configure a DSN for a Microsoft Access or Microsoft SQL Server 6.5 database.

On the Edit Data Source Name page, SequeLink 4.51a appears in this field.

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 database driver configured for this DSN (SequeLink). It is a nonconfigurable field.

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

SQLnkDSN*

This is the name of the DSN configured by running the ./setsqllnk utility. For more information, see "Configuring SequeLink" in this chapter.

Database*

For Microsoft Access databases, this is the absolute path name of the Access MDB file on the Windows-based server.

For Microsoft SQL Server 6.5 databases, this is the database name of the SQL Server database.

LogonID

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.

PreFetchRows

This is an advanced feature. Do not change this setting without first contacting Sun Chili!Soft Customer Support. The default is 30.

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.

EnableWarnings

This is an advanced feature. Do not change this setting without first contacting Sun Chili!Soft Customer Support. This parameter is enabled by default (the check box is selected).

UidPwdMapping

Microsoft SQL Server requires two sets of usernames and passwords, one for accessing the host server, and one for accessing the database. Only one pair can be passed via the connection string (or the LoginID/password configured here). The other must be configured into the SqlnkDSN, as described in "Configuring SequeLink" in this chapter.

When UidPwdMapping is enabled (the check box is selected), the LoginID represents the host. When UidPwdMapping is disabled (the check box is not selected) the LoginID represents the database. This parameter is disabled by default.

AllowBatchStatements

This is an advanced feature. Do not change this setting without first contacting Sun Chili!Soft Customer Support. This parameter is disabled by default (the check box is not selected).

EnableScrollableCursors

This option enables the use of cursor types other than "ForwardOnly." This parameter is enabled by default (the check box is selected).

DataDictionary

This is an advanced feature. Do not change this setting without first contacting Sun Chili!Soft Customer Support.