[python] Python에서 MSSQL 사용하기


Python module:
http://pymssql.sourceforge.net

장애 1)

Traceback (most recent call last):
File "/email_server/src/server/spam/xspam_centerlog.py", line 8, in ?
File "/usr/local/python2.4.2/lib/python2.4/site-packages/pymssql.py", line 30, in ?
import _mssql
ImportError: /usr/local/python2.4.2/lib/python2.4/site-packages/_mssql.so: undefined symbol: dbcolinfo

조치 1)

http://www.freetds.org/software.html 에서 FreeTDS-stable.tgz 을 다운받아 설치한다.
직접 다운받기 : http://ibiblio.org/pub/linux/alpha/fre ··· able.tgz

장애 2)

Traceback (most recent call last):
File "/email_server/src/server/spam/xspam_common.py", line 79, in xspam_main
File "/email_server/src/server/spam/xspam_centerlog.py", line 20, in proc_main
File "/usr/local/python2.4.2/lib/python2.4/site-packages/pymssql.py", line 328, in connect
con = _mssql.connect(dbhost, dbuser, dbpasswd)
error: DB-Lib error message 20009, severity 9:
Server is unavailable or does not exist.

조치 2)

dbhost에 port까지 명시한다.

con = pymssql.connect( host='192.168.0.10:1433', user='sa', password='', database='temp')
cur = con.cursor()

"프로그래밍 / Python" 분류의 다른 글

[python] mod_python 오류 (0)2008/02/25
[python] ClamAV Oversized.Zip FOUND 문제. (0)2008/01/22
[python] Python C Module 만들기 (0)2006/11/28
[python] eclipse에서 python 작업하기 (0)2006/08/16
[python] 함수 포인터 (0)2006/06/21
[python] Python으로 작성된 Hellow, World! (0)2006/05/16


Powered by Textcube