ASE 15.0.3 full install on Linux 32bit.
First we need to install unixODBC:
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:
Description = Sybase ODBC Driver
Driver = /opt/sybase/ODBC-12_5/lib/libsybdrvodb.so
FileUsage = -1
Change to:
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:
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
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:
If you wanted a system wide dsn:
« Fast Foward Radio – a positive take on the future with Phil Bowermaster & Stephen Gordon Why oh why is working with XML so bloomin’ difficult in Perl? »
To test the dsn, you can use unixODBC’s isql:
% /usr/bin/isql dbadev1
Wayne Allen ran into the same problem as I did with the Sybase ODBC drivers.
When you run the Sybase setup (in GUI mode “setup” or console mode “setup -console”), you can choose where to install the Sybase software. In this case, I chose /opt/sybase.
Nope, the ODBC drivers from Sybase are native Linux binaries.
Well, there isn’t a direct link. You need to download the Software Development Kit.. which you can only get from Sybase http://www.sybase.com/linux
BTW I’m the one running PHP on Ubuntu, and it is working, along with Apache… Just need to be able to connect to the Sybase server
good article,can’t hardly wait for more article.. thanks