Difference between revisions of "Sybase"

From ArchWiki
Jump to: navigation, search
m (Install command line client tool)
(6 intermediate revisions by 4 users not shown)
Line 1: Line 1:
[[Category:Daemons and system services (English)]]
+
[[Category:Database management systems]]
[[Category:Database management systems (English)]]
+
[[Category:HOWTOs (English)]]
+
 
{{stub}}
 
{{stub}}
{{i18n|Sybase}}
 
 
 
Sybase is a multi-threaded, multi-user SQL database. For more information about features, see the [http://www.mysql.com official homepage].
 
Sybase is a multi-threaded, multi-user SQL database. For more information about features, see the [http://www.mysql.com official homepage].
 
== Install Sybase Client ==
 
== Install Sybase Client ==
For those user don't want to install sybase server, it could install the freetds package:
+
For those user do not want to install sybase server, it could install the freetds package:
 
  # pacman -S freetds
 
  # pacman -S freetds
 
After installing freetds you should edit the config file as root:
 
After installing freetds you should edit the config file as root:
  # vi /etc/conf.d/freetds/freetds.conf
+
  # vi /etc/freetds/freetds.conf
  
 
== Install command line client tool ==
 
== Install command line client tool ==

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