搞了半天总算解决了python连接mssql2005的问题
我在windows下,用python2.5加上pymssql插件完成的。写出来供大家参考。
# -*- coding=gbk -*-
import pymssql
conn = pymssql.connect(host='172.23.65.XX, user='sa', password='sa123', database='agr')
cur = conn.cursor()
import pymssql
conn = pymssql.connect(host='172.23.65.XX, user='sa', password='sa123', database='agr')
cur = conn.cursor()
sql ='SELECT * FROM agr '
cur.execute(sql)
#row = cur.fetchone()
#while row:
# print "ID=%s, Name=%s"% (row[0], row[1])
# row = cur.fetchone()
#row = cur.fetchone()
#while row:
# print "ID=%s, Name=%s"% (row[0], row[1])
# row = cur.fetchone()
roow = cur.fetchall()
for roo in roow:
print roo
print roo
conn.close()
转载于:https://blog.51cto.com/wnxwf/218809