阅读:10694回复:2
Python2.7之链接MSSQLServer2008数据库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() |
|