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
I am trying to setup unixODBC and the Sybase ODBC drivers that ships with the Open Client 15.0 32-bit (RH) on a Ubuntu 10.4 installation.
All works fine until the actual test:
usr/bin/isql TEST sa **** -v
[01000][unixODBC][Driver Manager]Can’t open lib ‘/opt/sybase/DataAccess/ODBC/lib/libsybdrvodb.so’ : file not found
[ISQL]ERROR: Could not SQLConnect
and I get this error. Of course the file exists, but;
ldd /opt/sybase/DataAccess/ODBC/lib/libsybdrvodb.so
linux-gate.so.1 => (0x003b6000)
libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0x001f5000)
libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0x009e2000)
libstdc++-libc6.2-2.so.3 => not found
libm.so.6 => /lib/tls/i686/cmov/libm.so.6 (0x00edc000)
libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0x001f9000)
/lib/ld-linux.so.2 (0x00e67000)
so for some reason the libstdc++-lib6.2-2.so3 is not found.
Have you had any luck installing the sybase ODBC drivers on Ubuntu 10.4? would you have any clues of what lib I need to update/install?
Hi Danny,
With Ubuntu after 8.10, you will need to install libstdc++5 as Sybase’s ODBC driver is built with the older library.
sudo aptitude install libstdc++5
let me know if it helps
Jason
Hello Jason,
Thank you!
I found the missing lib in the package: libstdc++2.10-glibc2.2_2.95.4-24_i386.deb
after installing this package all my dependencies problems were solved and I was able to use the Sybase ODBC driver.
It is of course not great to have this dependency, but the other options are using the native ct-lib (have to write a driver myself) or use the FreeTDS ODBC drivers.
What are you experiences with using CT-lib, vs the Sybase ODBC? -I mean performance wise.
cheers!
To be honest, for the applications I’ve run into, I have yet to see real difference in performance between CT-LIB, ODBC or JDBC in the driver layer. Most of the bottlenecks tended to be with:
1 Poor queries (no covering indexes or just bad SQL coding)
2 Application design
3 Sybase ASE misconfiguration
4 OS misconfiguration
Way way down the list would be the connection drivers. That’s not to say that there aren’t issues with the various drivers and abstraction layers though.
Jason