按照教程走的流程百度了也找不到解决方法
import pymssql
conn= pymssql.connect(host=“DESKTOP-BS7O8CH”,
user=“sa”,
password=“123”,
database=“Ceshi”,
charset=“utf8”
)
cursor_1=conn.cursor() #获取游标
sql=“insert into user(username,password) values(%s,%s)”
param=(“张三”,“123456”)
n=cursor_1.execute(sql,param)
conn.commit()
cursor_1.close()
conn.close()
报错信息:
Traceback (most recent call last):
File “E:\Eclipse -Workplace\demo3\num2.py”, line 12, in
charset=“utf8”
File “src\pymssql.pyx”, line 642, in pymssql.connect
pymssql.OperationalError: (20009, ‘DB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (DESKTOP-BS7O8CH:1433)\nNet-Lib error during Unknown error (10060)\n’)