How do I create an application server (3-Tier) Multi-Tier DSN to connect to Sybase?



You must pass the following values in your Multi-Tier DSN:

Parameter	Value
Name	A descriptive name that identifies the Data Source.
Server	Passes the hostname or IP address of the server on which the Multi-Tier Request Broker listens. Also passes the TCP port on which the Broker listens. The format is host:port.
Password	This is a valid Sybase database password.
Login ID	This is a valid Sybase database username.
Database	This is the name of the Sybase database.
Connect Options	This passes -H hostname or IP address of the machine that contains Sybase -P TCP port on which Sybase listens and -V TDS version which defaults to 5.0. For example: -H 192.75.11.235 -P 4100 -V 5.0
Domain	This value corresponds to a Domain Alias that appears in the [Domain Aliases] section of the Session Rules Book. The default Domain Alias is "Sybase." Custom Domain Aliases may take any form.

Note: The Domain field is synonymous with the SVT parameter in Unix odbc.ini files. The Connect Options field is synonymous with the Options field in Unix odbc.ini files.