能试的方法都试过了，还请大佬帮忙看一下
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: (18456, b"\xe7\x94\xa8\xe6\x88\xb7 'sa' \xe7\x99\xbb\xe5\xbd\x95\xe5\xa4\xb1\xe8\xb4\xa5\xe3\x80\x82DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (DESKTOP-AT6GGIA:1433)\n")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "D:\桌面文件夹\成信大\Python\灰度模型\与数据库的链接.py", line 2, in <module>
conn = pymssql.connect(server = 'DESKTOP-AT6GGIA' , user = 'sa' , password = 'llm1218' , database = 'elevator')
File "src\pymssql.pyx", line 642, in pymssql.connect
pymssql.OperationalError: (18456, b"\xe7\x94\xa8\xe6\x88\xb7 'sa' \xe7\x99\xbb\xe5\xbd\x95\xe5\xa4\xb1\xe8\xb4\xa5\xe3\x80\x82DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (DESKTOP-AT6GGIA:1433)\n")
数据库连接字符串 添加charset='CP936' 就OK了
D:\PyCharm2020\plant_scan\venv\Scripts\python.exe D:/PyCharm2020/plant_scan/123.py
Traceback (most recent call last):
File "src\pymssql.pyx", line 636, in pymssql.connect
File "src_mssql.pyx", line 1964, in mssql.connect
File "src_mssql.pyx", line 682, in _mssql.MSSQLConnection._init__
File "src_mssql.pyx", line 1690, in _mssql.maybe_raise_MSSQLDatabaseException
_mssql.MSSQLDatabaseException: (18456, b"\xe7\x94\xa8\xe6\x88\xb7 'root' \xe7\x99\xbb\xe5\xbd\x95\xe5\xa4\xb1\xe8\xb4\xa5\xe3\x80\x82DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (127.0.0.1)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (127.0.0.1)\n")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "D:/PyCharm2020/plant_scan/123.py", line 23, in
connect = pymssql.connect(host="127.0.0.1", user='root',password="xiehao123") # port=8080,
File "src\pymssql.pyx", line 642, in pymssql.connect
pymssql.OperationalError: (18456, b"\xe7\x94\xa8\xe6\x88\xb7 'root' \xe7\x99\xbb\xe5\xbd\x95\xe5\xa4\xb1\xe8\xb4\xa5\xe3\x80\x82DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (127.0.0.1)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (127.0.0.1)\n")
Process finished with exit code 1
我的也是
D:\pythonProject\venv\Scripts\python.exe D:/pythonProject/new.py
Traceback (most recent call last):
File "src\pymssql_pymssql.pyx", line 646, in pymssql._pymssql.connect
File "src\pymssql_mssql.pyx", line 2108, in pymssql._mssql.connect
File "src\pymssql_mssql.pyx", line 700, in pymssql._mssql.MSSQLConnection.init
File "src\pymssql_mssql.pyx", line 1817, in pymssql._mssql.maybe_raise_MSSQLDatabaseException
File "src\pymssql_mssql.pyx", line 1834, in pymssql._mssql.raise_MSSQLDatabaseException
pymssql._mssql.MSSQLDatabaseException: (18456, b'DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\n')
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "D:\pythonProject\new.py", line 10, in
conn = conn()
File "D:\pythonProject\new.py", line 4, in conn
connect = pymssql.connect(host = 'localhost',database = '学校卫生',charset='CP936')
File "src\pymssql_pymssql.pyx", line 652, in pymssql._pymssql.connect
pymssql._pymssql.OperationalError: (18456, b'DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\n')
1.防火墙关掉
2.配置数据库 允许所有人接入
3.测试数据库是否成功运行
首先，命令行能不能连接数据库