Difference between revisions of "Sybase"

From ArchWiki
Jump to: navigation, search
(Redirect to ODBC freetds section.)
 
(8 intermediate revisions by 6 users not shown)
Line 1: Line 1:
[[Category:Database management systems]]
+
#REDIRECT [[Open Database Connectivity]]
{{stub}}
 
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 ==
 
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 ==
 
[https://aur.archlinux.org/packages.php?ID=18441 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()
 

Latest revision as of 08:21, 4 December 2017