首页
学习
活动
专区
工具
TVP
发布
精选内容/技术社群/优惠产品,尽在小程序
立即前往
您找到你想要的搜索结果了吗?
是的
没有找到

pycharm 连接数据库报错[通俗易懂]

C:\Users\MACHENIKE\PycharmProjects\untitled9\venv\Scripts\python.exe C:/Users/MACHENIKE/PycharmProjects/untitled11/venv/Online-Bookstore-Management-System-master/v1.0/Book_informationUI.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 ‘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”)

01

python操作sqlserver

# coding=gbk import sys   import pymssql #尝试数据库连接 try:     conn = pymssql.connect(host="192.168.1.43",user="sa",password="sa01!", database="master") except pymssql.OperationalError, msg:     print "error: Could not Connection SQL Server!please check your dblink configure!"     sys.exit() else:     cur = conn.cursor() #查询数据库 query="select name, database_id, recovery_model_desc  from sys.databases"   cur.execute(query) conn.commit   rows = cur.fetchall() print ('                      ') print ('-----结果返回中------- ') print ('                     ') for (name,database_id,recovery_model_desc) in rows:     database_id=bytes(database_id) #将int转换转换为字符串类型     print ('数据库名:' +str(name)+';')          print ( '数据库id:' +database_id )      print ( '数据库恢复模式:'+str(recovery_model_desc) )     print ('                      ') print ('-----以上是所有结果!------- ')  #关闭连接,释放资源  cur.close()  conn.close()

02
领券