链接sqlserver
代码:
import pymssql
server = "(local)"
user = "sa"
password = "123456"
database = "cmc"
conn = pymssql.connect(server,user,password,database)
cursor = conn.cursor()
if cursor:
print("链接成功")
conn.close()
报错:
pymssql._pymssql.OperationalError: (20009, b'DB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (localhost)\nNet-Lib error during Unknown error (10061)\nDB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (localhost)\nNet-Lib error during Unknown error (10061)\n')
按照网上说的修改了tcp/ip 属性 启用127.0.0.1 启用了sql server brower
问题依旧 仍然连不上sql
连接代码格式参考:
db= pymysql.connect(host="localhost",user="root",password="123456",db="test",port=3306)