%META:TOPICPARENT{name="ConfigTroubleshootASE"}%
How do I create a Single-Tier DSN to connect to Sybase?   %BR%
%BR%
Single-Tier Data Sources Names are simple to create. You simply pass: %BR%
%BR%
* An arbitrary name for your data source
*  A default <nop>ServerType of "Sybase 11/ Sybase 12"
* The Sybase server or instance name
* The hostname or IP address on which Sybase resides
* The TCP port on which Sybase listens
* A valid username, as required
* A valid password, as required%BR%
%BR%
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: %BR%
%BR%
{{{
[sql_lite]
Driver				         = /usr/openlink/lib/sql_ mt_lt.so
<nop>ServerType			 = Sybase # Do Not Use Another Value
Username			    = sa
Password			    = sa
Database			    = pubs
Options				     = -H 192.136.12.214 -P 4100  -V 5.0   # Passes a hostname, listening port, and [[TDS version 5.0 for Sybase]]
ReadOnly			  = no
DeferLongFetch		        = no
JetFix				     = no
Description			   = Sample Sybase Lite Connection
}}}