windows环境下通过pyodbc连接SQL SERVER

 

import pyodbc
cnxc=pyodbc.connect('DRIVER={SQL Server};SERVER=wang-PC\SQLEXPRESS;DATABASE=data_wang;UID=sa;PWD=password')
cursor = cnxc.cursor()
cursor.execute("SELECT * FROM [data_wang].[dbo].[coupons]")
row=cursor.fetchall()
for i in row:
    print i
cursor.execute("SELECT * FROM [data_wang].[dbo].[coupons]")
row=cursor.fetchone()
print row
print row.cNo

 

 

另附：

　　pyodbc模块下载地址：http://code.google.com/p/pyodbc/

　　Getting start:http://code.google.com/p/pyodbc/wiki/GettingStarted