<docbook><section><title>HowDoICreateASingle-TierDSNToConnectToSybaseASA</title><para> How do I create a Single-Tier DSN to connect to Sybase ASA?</para><para>Single-Tier Data Sources Names are simple to create.
 You simply pass:</para><para>   1.
 An arbitrary name for your data source    2.
 A default <ulink url="ServerType">ServerType</ulink> of &quot;Sybase 11/ Sybase 12&quot;    3.
 The Sybase server or instance name    4.
 The hostname or IP address on which Sybase resides    5.
 The TCP port on which Sybase listens    6.
 A valid username, as required    7.
 A valid password, as required</para><para>      You may easily create Sybase Data Source names using the Windows ODBC Data Sources Administrator or the HTTP-based iODBC Data Sources Administrator (Unix).
 If you choose to edit Unix odbc.ini files, take note of the following Data Source Name format:</para><programlisting>      [sql_lite]
      Driver				         = /usr/openlink/lib/sql_ mt_lt.so
      ServerType			 = Sybase # Do Not Use Another Value
      Username			    = sa
      Password			    = sa
      Database			    = pubs
      Options				     = -S SYBASE -H 192.136.12.214 -P 4100  -V 5.0   # Passes a Sybase instance name, hostname, listening port, and TDS version 5.0 for Sybase?
      ReadOnly?			  = no
      DeferLongFetch?		        = no
      JetFix?				     = no
      Description			   = Sample Sybase ASA Lite Connection
</programlisting></section></docbook>