Uda Wiki Web

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