问题描述

求救 pymssql怎么都连不上 服务中sql server代理也启动不了

Traceback (most recent call last):  File ""pymssql.pyx"" line 630 in pymssql.connect (pymssql.c:10097)  File ""_mssql.pyx"" line 1887 in _mssql.connect (_mssql.c:20477)  File ""_mssql.pyx"" line 631 in _mssql.MSSQLConnection.__init__ (_mssql.c:6156)  File ""_mssql.pyx"" line 1612 in _mssql.maybe_raise_MSSQLDatabaseException (_mssql.c:16426)_mssql.MSSQLDatabaseException: (20009 b'DB-Lib error message 20009 severity 9:nUnable to connect: Adaptive Server is unavailable or does not existnNet-Lib error during Unknown error (10035)n')During handling of the above exception another exception occurred:Traceback (most recent call last):  File ""C:/Python33/sqltest.py"" line 3 in <module>    conn = pymssql.connect(host = r""localhost"" port = r'1433' user = r'sa' password = r'412765442' database = r'test')  File ""pymssql.pyx"" line 636 in pymssql.connect (pymssql.c:10178)pymssql.OperationalError: (20009 b'DB-Lib error message 20009 severity 9:nUnable to connect: Adaptive Server is unavailable or does not existnNet-Lib error during Unknown error (10035)n')

一晚上都弄不好啊！ 真烦！错误提示在上面

import pymssqlconn = pymssql.connect(host = r""localhost"" port = r'1433' user = r'sa' password = r'412765442' database = r'test')cur = conn.cursor()if not cur:    raise(NameError连接数据库失败"")print(""===================================="")reslist = cur.execute(""select * from dbo.person_table"")for (id name) in reslist:    print(str(id) name)

以上是代码 求救啊！ sql server代理在启动时也会失败!图片说明

解决方案

nNet-Lib提示不存在，好好检查下

解决方案二：
参考install pymssql and how to deal with DB-Lib error message 20009 severity 9
先看看你的环境变量里面TDSVER的版本是多少，如果不对，改成正确的版本试试