Difference between revisions of "Sybase"

From ArchWiki
Jump to: navigation, search
(rm stub template, deprecated)
m (Fengchao moved page User:Dlin/Sybase to Sybase: Prepare redirect to ODBC.)
(No difference)

Revision as of 08:20, 4 December 2017

Sybase is a multi-threaded, multi-user SQL database. For more information about features, see the official homepage.

Install Sybase Client

For those user do not want to install sybase server, it could install the freetds package:

# pacman -S freetds

After installing freetds you should edit the config file as root:

# vi /etc/freetds/freetds.conf

Install command line client tool

sqshAUR is in the AUR.

Install Sybase Server

Configuration

Enable remote access

Upgrading

Troubleshooting

Install Sybase python binding

[Download driver here http://python-sybase.sourceforge.net/] (v0.39 is workable)

for sybase ocs installed

python setup.py install

for use freetds

root# SYBASE=/usr SYBASE_OCS= CFLAGS="-DHAVE_FREETDS" python setup.py install

Sample Code

con=Sybase.connect('DSN','USER','PASS','DB',locking=0)
c=con.cursor()
c.execute('select count(*) from TABLE')
c.fetchone()