Difference between revisions of "Sybase"

From ArchWiki
Jump to: navigation, search
m (cleanup, rm red links)
m (Install command line client tool: convert AUR link)
 
Line 9: Line 9:
  
 
== Install command line client tool ==
 
== Install command line client tool ==
[https://aur.archlinux.org/packages.php?ID=18441 sqsh] is in the [[AUR]].
+
{{AUR|sqsh}} is in the [[AUR]].
  
 
== Install Sybase Server ==
 
== Install Sybase Server ==

Latest revision as of 21:14, 1 October 2013

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

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