Difference between revisions of "Sybase"

From ArchWiki
Jump to: navigation, search
Line 1: Line 1:
[[Category:Daemons and system services]]
 
 
[[Category:Database management systems]]
 
[[Category:Database management systems]]
 
{{stub}}
 
{{stub}}

Revision as of 07:03, 29 November 2012

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

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

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