import pymssql import pandas as pd import numpy as np from odps import ODPS # server默认为127.0.0.1,如果打开了TCP动态端口的需要加上端口号,如'127.0.0.1:1433' # user默认为sa # password为自己设置的密码 # database为数据库名字 server = '127.0.0.1' user = "*****" password = "*******" database = "*******" conn = pymssql.connect(server, user, password, database) # 可简化为conn = pymssql.connect(host='localhost', user='sa', password='123456', database='pubs') cursor = conn.cursor() # cursor.execute('SELECT * FROM titles') # print( cursor.fetchall() ) print("连接成功")
Traceback (most recent call last):
File "src\pymssql\_pymssql.pyx", line 647, in pymssql._pymssql.connect
File "src\pymssql\_mssql.pyx", line 2109, in pymssql._mssql.connect
File "src\pymssql\_mssql.pyx", line 701, in pymssql._mssql.MSSQLConnection.__init__
File "src\pymssql\_mssql.pyx", line 1818, in pymssql._mssql.maybe_raise_MSSQLDatabaseException
File "src\pymssql\_mssql.pyx", line 1835, in pymssql._mssql.raise_MSSQLDatabaseException
pymssql._mssql.MSSQLDatabaseException: (18456, b"\xe7\x94\xa8\xe6\x88\xb7 'bsyread' \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:\刘建国\Python\pythonproject\venv\工作.py", line 19, in <module>
conn = pymssql.connect(server, user, password, database)
File "src\pymssql\_pymssql.pyx", line 653, in pymssql._pymssql.connect
pymssql._pymssql.OperationalError: (18456, b"\xe7\x94\xa8\xe6\x88\xb7 'bsyread' \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")