python sql server 使用非默认端口_python链接数据库SQL Server 2005出错怎么办???附解决方案以及开启TCP/IP协议和查看默认端口的过程...

import pymssql

conn=pymssql.connect(host='127.0.0.1:1433',user='sa',password='jxn',database='scott',charset="UTF-8")

'''

如果和本机数据库交互，只需修改链接字符串

conn=pymssql.connect(host='.',database='Michael')

'''

cur=conn.cursor()

cur.execute('select * from emp')

#如果update/delete/insert记得要conn.commit()

#否则数据库事务无法提交

print(cur.fetchall())

cur.close()

conn.close()

一开始运行上面代码老是出现以下错误：

Traceback (most recent call last):

File "src\pymssql.pyx", line 636, in pymssql.connect

File "src\_mssql.pyx", line 1952, in _mssql.connect

File "src\_mssql.pyx", line 673, in _mssql.MSSQLConnection.__init__

File "src\_mssql.pyx", line 1680, in _mssql.maybe_raise_MSSQLDatabaseException

_mssql.MSSQLDatabaseException: (20009, b'Unknown error')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "", line 1, in conn=pymssql.connect(host='127.0.0.1',user='sa',password='jxn',database='scott',charset='utf-8')

File "src\pymssql.pyx", line 642, in pymssql.connect

pymssql.OperationalError: (20009, b'Unknown error')

查看了网上很多的资料，都找不到答案，添加了端口号：没用，添加了charset:没用，TCP/IP开启：没用，

有的网友说要不试一下用pyodbc进行数据库连接？好吧，我不想放弃，就又去安装pyodbc，并找了段测试代码：

import pyodbc

cnxn = pyodbc.connect('DRIVER={SQL Native Client};SERVER=127.0.0.1,1433;DATABASE=scott;UID=sa;PWD=jxn')

cursor = cnxn.cursor()

cursor.execute("select * from emp")

rows =