How do I create a Single-Tier DSN to connect to Sybase? Single-Tier Data Sources Names are simple to create. You simply pass: An arbitrary name for your data source A default 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 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: [sql_lite] Driver = /usr/openlink/lib/sql_ mt_lt.so 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