新手求肋 python 2.6.5 pymssql 远程连接问题
用python 2.6.5 不能连接远程的sql sever2005 服务器 连接本地服务器正常
用python 2.7 可以正常连接
python 2.6.5 远程连接错误
Traceback (most recent call last):
File "<pyshell#2>", line 1, in <module>
pymssql.connect(host='192.168.255.5\sql2005', user='dev_user', password='fdasdshfkjh#@$#', database='[cqjob-net]',charset="UTF-8", as_dict=True)
File "pymssql.pyx", line 456, in pymssql.connect (pymssql.c:6017)
rows.append(self.getrow())
InterfaceError: Connection to the database failed for an unknown reason.
因为用sphinx + python 万能数据源,所以必须使用 python2.6