ASE 15.0.3 full install on Linux 32bit.
First we need to install unixODBC:
% sudo aptitude install unixodbc unixodbc-bin unixodbc-dev
Because of a bug within the Sybase ODBC install, we need to change /opt/sybase/DataAccess/ODBC/samples/drivertemplate.txt.
/opt/sybase/DataAccess/ODBC/samples/drivertemplate.txt:
[Adaptive Server Enterprise]
Description = Sybase ODBC Driver
Driver = /opt/sybase/ODBC-12_5/lib/libsybdrvodb.so
FileUsage = -1
Description = Sybase ODBC Driver
Driver = /opt/sybase/ODBC-12_5/lib/libsybdrvodb.so
FileUsage = -1
Change to:
[Adaptive Server Enterprise]
Description = Sybase ODBC Driver
Driver = /opt/sybase/DataAccess/ODBC/lib/libsybdrvodb.so
FileUsage = -1
Description = Sybase ODBC Driver
Driver = /opt/sybase/DataAccess/ODBC/lib/libsybdrvodb.so
FileUsage = -1
This template file is used to install the ODBC driver with unixODBC:
odbcinst -i -d -f /opt/sybase/DataAccess/ODBC/samples/drivertemplate.txt
Currently Sybase’s ODBC driver does not have a GUI component for unixODBC. I’m waiting on the bug #. Once I have it, I’ll update this post.
Now we are ready to define an ODBC dsn. We will need to create a template file to do so:
dbadev1.dsn
[dbadev1]
Description=Sybase ODBC Data Source
UserID=sa
Password=password
Driver=Adaptive Server Enterprise
Server=dba-dev1
Port=5000
Database=sybase_dba
UseCursor=1
Description=Sybase ODBC Data Source
UserID=sa
Password=password
Driver=Adaptive Server Enterprise
Server=dba-dev1
Port=5000
Database=sybase_dba
UseCursor=1
To add it to unixODBC we need to run:
odbcinst -i -s -f dbadev1.dsn
If you wanted a system wide dsn:
sudo odbcinst -i -s -l -f dbadev1.dsn
