Sample ODBC DSN Entry

Sample ODBC DSN entry in the odbc.ini file.

[ArchiveDSN]
Description						= Sybase ODBC Data Source
UID									= dba
PWD									= sql
Driver								= Adaptive Server Enterprise
ENG									= datawarehouse_server
DBN									= books
LINKS								= tcpip(host=dbServer;port=2638)
Parameter Description
UID User ID in Sybase IQ.
PWD Password for the user ID in Sybase IQ.
Driver Name of the driver when using ODBC driver manager. Ensure the name of the driver matches one of the driver information sections in the odbcinst.ini file. This parameter is not required when using the Sybase IQ ODBC driver directly. The odbcinst.ini file is found in:
  • /etc directory on Linux
  • /windows directory on Windows.
ENG Name of the Sybase IQ server.
DBN Name of the database.
LINKS Network protocol used to connect to the database.