Sybase

From ArchWiki
Revision as of 20:04, 23 November 2010 by Thestinger (Talk | contribs) (Install command line client tool)

Jump to: navigation, search

Tango-document-new.pngThis article is a stub.Tango-document-new.png

Notes: please use the first argument of the template to provide more detailed indications. (Discuss in Talk:Sybase#)

This template has only maintenance purposes. For linking to local translations please use interlanguage links, see Help:i18n#Interlanguage links.


Local languages: Català – Dansk – English – Español – Esperanto – Hrvatski – Indonesia – Italiano – Lietuviškai – Magyar – Nederlands – Norsk Bokmål – Polski – Português – Slovenský – Česky – Ελληνικά – Български – Русский – Српски – Українська – עברית – العربية – ไทย – 日本語 – 正體中文 – 简体中文 – 한국어


External languages (all articles in these languages should be moved to the external wiki): Deutsch – Français – Română – Suomi – Svenska – Tiếng Việt – Türkçe – فارسی

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

Install Sybase Client

For those user don't 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/conf.d/freetds/freetds.conf

Install command line client tool

sqsh is in the AUR.

Install Sybase Server =

download from the official sybase site.
stub

Configuration

stub

Enable remote access

stub

Upgrading

stub

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()