一、下载Sybase module for Python
$ wget http://nchc.dl.sourceforge.net/project/python-sybase/python-sybase/python-sybase-0.40pre2/python-sybase-0.40pre2.tar.gz
二、解压
tar xzvf python-sybase-0.40pre2.tar.gz
三、修改setup.py
把 sybase = '/opt/sybase' 改为sybase = '/opt/sybase/OCS-16_0'
四、编译安装
python setup.py build
sudo python setup.py install
五、测试
$ python
Python 2.7.6 (default, Jun 22 2015, 17:58:13)
[GCC 4.8.2] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import Sybase
>>> Sybase.connect('MYMOTIFVOSTRO145480', 'sa', 'wxwpxh')
如果没有错误信息、说明安装成功了
sybtest.py
import sys, string, Sybase
db = Sybase.connect('MYMOTIFVOSTRO145480', 'sa', 'wxwpxh')
c = db.cursor()
if len(sys.argv) > 1:
c.execute('select c.text from syscomments c, sysobjects o'
' where o.name = @name and o.type = "P" and c.id = o.id'
' order by c.colid', {'@name': sys.argv[1]})
print string.join([row[0] for row in c.fetchall()], '')
else:
c.execute('select name from sysobjects where type = "P" order by name')
print string.join([row[0] for row in c.fetchall()], '\n')
$ python sybtest.py
sp_addconf
sp_autoformat
sp_aux_checkroleperm
sp_aux_getsize
sp_check_remote_tempdb
sp_configure
sp_dboption
sp_dboption_flmode
sp_dropdevice
sp_getmessage
sp_instmsg
sp_loaddbupgrade
sp_namecrack
sp_probe_xact
sp_procxmode
sp_prtsybsysmsgs
sp_remotesql
sp_validlang