Python Sybase module

From MetaWiki

Jump to: navigation, search

This is just what worked for me...


You need the FreeTDS libraries first, the Ubuntu Intrepid package did not work for me. So I need to compile a separate copy in /usr/local/freetds

1. Get the latest from http://www.freetds.org unpack and compile

tar xvfz freetds-stable.tgz

./configure --prefix=/usr/local/freetds

make

make install


2. Then download the Sybase Python module from http://python-sybase.sourceforge.net

tar xvfz python-sybase-0.38.tar.gz

cd python-sybase-0.38

export SYBASE=/usr/local/freetds

export CFLAGS="-DHAVE_FREETDS"

export LD_LIBRARY_PATH=/usr/local/freetds/lib:${LD_LIBRARY_PATH}

$ python setup.py install


That should be it, test with a simple program, example programs can be found at http://python-sybase.sourceforge.net

Note that you need to set LD_LIBRARY_PATH everytime otherwise I get "Sybase.Error: ct_results"