|
完整的错误提示如下
C:\Users\Tthink_pc\AppData\Local\Programs\Python\Python38\python.exe C:/Users/Tthink_pc/PycharmProjects/untitled3/test3.py
C:/Users/Tthink_pc/PycharmProjects/untitled3/test3.py:1: DeprecationWarning: Using or importing the ABCs from 'collecti**' instead of from 'collecti**.abc' is deprecated since Python 3.3, and in 3.9 it will stop working
import pymssql #引入pymssql模块
Traceback (most recent call last):
File "pymssql.pyx", line 636, in pymssql.connect
File "_mssql.pyx", line 1957, in _mssql.connect
File "_mssql.pyx", line 676, in _mssql.MSSQLConnection.__init__
File "_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 (127.0.0.1:1433)\nNet-Lib error during Unknown error (10061)\nDB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (127.0.0.1:1433)\nNet-Lib error during Unknown error (10061)\n')
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:/Users/Tthink_pc/PycharmProjects/untitled3/test3.py", line 12, in <module>
conn = conn()
File "C:/Users/Tthink_pc/PycharmProjects/untitled3/test3.py", line 5, in conn
connect =pymssql.connect(host='127.0.0.1:1433',user='sa',password='yl@2020',database='test')
File "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 (127.0.0.1:1433)\nNet-Lib error during Unknown error (10061)\nDB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (127.0.0.1:1433)\nNet-Lib error during Unknown error (10061)\n')
Process finished with exit code 1
SQLsever TCP已开
TCP里面的需要配置吗?
请问如何解决? 我安装的SQLserver2012的时候好像没有点local,这个有关系吗?求回答
|
|