Python2.7之链接MSSQLServer2008数据库

#coding=utf8
import pyodbc
import sys
  
##set system to utf-8##
reload(sys)
sys.setdefaultencoding('utf-8')
  
##MSSQLServer connect##
try:
    conn_mssql=pyodbc.connect('DRIVER={SQL Server};SERVER=数据库地址;port=端口号;DATABASE=数据库名;UID=用户名;PWD=密码;TDS_Version=8.0')
      
except Exception,e:
    print e
 
conn_mssql.close()