How to install Sybase’s ODBC driver on Ubuntu Linux 8.10 for ASE/IQ/Replication Server/SQL Anywhere/etc
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
To test the dsn, you can use unixODBC’s isql:
% /usr/bin/isql dbadev1
[...] someone else in your sphere is solving almost the same problem. Jason posted yesterday about installing ODBC on Ubuntu for Sybase which was one of the challenges we had as part of my previous post about getting Sybase’s ODBC/JDBC [...]
Wayne Allen ran into the same problem as I did with the Sybase ODBC drivers.