Configuring a Datasource

Use the unixODBC command line tool to configure a datasource for Adaptive Server ODBC Driver.

This is a datasource template:

[sampledsn]
Description=Sybase ODBC Data Source
UserID=sa
Password=
Driver=Adaptive Server Enterprise
Server=sampleserver
Port=4100
Database=pubs2
UseCursor=1

Execute:

#  odbcinst -i -s -f dsn template file

where dsn template file is the complete path to the Adaptive Server ODBC datasource template file. This creates entries for the datasource in the odbc.ini file.

Note: The exact command you need to configure ODBC datasources depends on the ODBC Driver Manager you are using.

Sybase iAnywhere ODBC Driver Manager
The Sybase iAnywhere ODBC Driver Manager uses the information provided in the odbc.ini file to locate the driver and other connection information. The ODBCINI variable defines the location of the odbc.ini file.

Parent topic: UNIX