Difference between revisions of "User:Dlin/Sybase"

From ArchWiki
Jump to: navigation, search
(rm stub template, deprecated)
 
(6 intermediate revisions by 4 users not shown)
Line 1: Line 1:
[[Category:Database management systems]]
 
{{stub}}
 
 
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 ==
Line 9: Line 7:
  
 
== 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 ==
download from the official sybase site.
 
[[stub]]
 
  
 
== Configuration ==
 
== Configuration ==
[[stub]]
+
 
 
=== Enable remote access ===
 
=== Enable remote access ===
[[stub]]
+
 
 
== Upgrading ==
 
== Upgrading ==
[[stub]]
 
  
 
== Troubleshooting ==
 
== Troubleshooting ==

Latest revision as of 14:06, 18 September 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()