python连接sql server失败_请问pycharm连接SQL server是哪里出错了

最新推荐文章于 2023-05-03 03:35:22 发布

weixin_39579548

最新推荐文章于 2023-05-03 03:35:22 发布

阅读量998

点赞数

文章标签： python连接sql server失败

本文链接：https://blog.csdn.net/weixin_39579548/article/details/111436953

版权

在尝试使用Python的pymssql模块连接到SQL Server时，遇到了20009错误，提示无法连接到Adaptive Server (DESKTOP-31KAUFD:1433)并伴随Net-Lib错误10060。问题可能在于服务器未响应或配置不正确。错误堆栈显示在`pymssql.connect()`时触发了`MSSQLDatabaseException`。

摘要由CSDN通过智能技术生成

该楼层疑似违规已被系统折叠隐藏此楼查看此楼

D:\python\python.exe "D:\pycharm\PyCharm Community Edition 2017.3.4\helpers\pydev\pydevd.py" --multiproc --qt-support=auto --client 127.0.0.1 --port 62197 --file D:/pycharm/cyy.py

pydev debugger: process 6948 is connecting

Connected to pydev debugger (build 173.4674.37)

Traceback (most recent call last):

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

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

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

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

_mssql.MSSQLDatabaseException: (20009, b'DB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (DESKTOP-31KAUFD:1433)\nNet-Lib error during Unknown error (10060)\n')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "D:\pycharm\PyCharm Community Edition 2017.3.4\helpers\pydev\pydevd.py", line 1668, in

main()

File "D:\pycharm\PyCharm Community Edition 2017.3.4\helpers\pydev\pydevd.py", line 1662, in main

globals = debugger.run(setup['file'], None, None, is_module)

File "D:\pycharm\PyCharm Community Edition 2017.3.4\helpers\pydev\pydevd.py", line 1072, in run

pydev_imports.execfile(file, globals, locals) # execute the script

File "D:\pycharm\PyCharm Community Edition 2017.3.4\helpers\pydev\_pydev_imps\_pydev_execfile.py", line 18, in execfile

exec(compile(contents+"\n", file, 'exec'), glob, loc)

File "D:/pycharm/cyy.py", line 4, in

conn=pymssql.connect(host='DESKTOP-31KAUFD',user='cyy',password='cyycyy',database='JXGL',charset='utf8')

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

pymssql.OperationalError: (20009, b'DB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (DESKTOP-31KAUFD:1433)\nNet-Lib error during Unknown error (10060)\n')