Parameter
|
Explanation
|
DSN*
Data Source Name*
|
Name of the data source name (DSN) you are configuring.
|
Description
|
Description of the DSN to help distinguish it from others.
|
Database type*
|
Indicates for which type of database you are configuring this DSN (Microsoft SQL Server).
|
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 (Microsoft SQL Server). This 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. This is a configurable field.
|
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.
|
ServerIPAddress*
|
IP address of the SQL Server 7.0 or 2000 database server.
|
ServerPortNumber*
|
Port on which the SQL Server 7.0 or 2000 database server is configured to listen. The default is 1433.
|
LogonID
|
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.
Caution: 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
|
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.
Caution: 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.
|