UdaWikiWeb.HowDoICreateAStandard2-TierMulti-TierDSNToConnectToSybaseASA
How do I create a standard (2-Tier) Multi-Tier DSN to connect to Sybase ASA?
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. |
| 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. |
| Database | This is the name of the Sybase database. |
| Connect Options | This passes -S Sybase instance name -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: -S SYBASE -H 192.75.11.235 -P 4100 -V 5.0 |
| Login ID | This is a valid Sybase database username. |
| Password | This is a valid Sybase database password. |
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.
