pymssql._pymssql.OperationalError: (18456这个问题怎么解决?

shiooge 2022-06-17 19:21:06

# 向SQL Server数据库中添加数据
import warnings
warnings.filterwarnings('ignore', category=DeprecationWarning)
from pymssql import *

conn=connect(host='localhost', user='sa', password='SQL2008r2', database='stuinfo5')
conn.autocommit(True)
cursor=conn.cursor()
operation='INSERT INTO students VALUES (%s, %s, %s, %s, %s)'
params=('2020182001', '王强', '男', '2002-03-21', 'wangqiang@163.com')
cursor.execute(operation, params)
print('成功添加1行数据!')
params=[
    ('2020182002', '王曜', '男', '2002-05-11', 'wangyao@163.com')
    ('2020182003', '李思思', '女', '2002-03-02', 'lisisig@shou.com')
    ('2020182004', '刘千梅', '女', '2001-09-20', 'liumei@sina.com')
    ('2020182005', '马亮', '男', '2002-05-11', 'maliangg@qq.com')
    ('2020182006', '肖嘉莉', '女', '2002-09-21', 'xiaolig@sina.com')
]
print('成功添加5行数据!')
cursor.executemany(operation, params)
cursor.execute('SELECT * FROM students')
rows=cursor.fetchall()
print('表数据如下:')
for row in rows:
    print(f'{row[0]}\t{row[1]}\t{row[2]}\t{row[3]}\t{row[4]}')
cursor.close()
conn.close()

程序执行后出现错误,提示如下:

E:\Python程序设计微课版\10.13 向SQL Server数据库中添加数据示例.py:14: SyntaxWarning: 'tuple' object is not callable; perhaps you missed a comma?
  ('2020182002', '王曜', '男', '2002-05-11', 'wangyao@163.com')
Traceback (most recent call last):
  File "src\pymssql\_pymssql.pyx", line 646, in pymssql._pymssql.connect
  File "src\pymssql\_mssql.pyx", line 2106, in pymssql._mssql.connect
  File "src\pymssql\_mssql.pyx", line 698, in pymssql._mssql.MSSQLConnection.__init__
  File "src\pymssql\_mssql.pyx", line 1815, in pymssql._mssql.maybe_raise_MSSQLDatabaseException
  File "src\pymssql\_mssql.pyx", line 1832, in pymssql._mssql.raise_MSSQLDatabaseException
pymssql._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 (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 "E:\10.13 向SQL Server数据库中添加数据.py", line 6, in <module>
    conn=connect(host='localhost', user='sa', password='SQL2008r2', database='stuinfo5')
  File "src\pymssql\_pymssql.pyx", line 652, in pymssql._pymssql.connect
pymssql._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 (localhost)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\n")
[Finished in 546ms]

请问这问题怎么解决?

...全文
2192 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
满恬 2022-12-28
  • 打赏
  • 举报
回复

求大佬,问题解决了吗

22,209

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server 疑难问题
社区管理员
  • 疑难问题社区
  • 尘觉
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧