python连接mssql数据库

一、连接报错

Adaptive Server is unavailable or does not exist

二、设置mssql服务

1.如下操作，将Start Mode改为自动后，启动SQL Server Browser服务

2.SQL Server网络配置 > TCP/IP > 右键 > 属性 > IP地址，启用127.0.0.1，点击 > 应用 > 确定。

3.服务 > SQL Server (MSSQLSERVER) > 右键 > 重新启动

4.python 连接mssql 数据

# ------- SQL connect -------
conmssql = pymssql.connect(
    server='DESKTOP-60FTAK4',
    user='testuser',
    password='1234',
    database='test',
    as_dict=True)
cursormssql = conmssql.cursor()
sql_insert='''INSERT INTO D_Customer (Registereddate,NickName,City,Score,Indate) VALUES ('2023-12-01','lixiao','BJ',100,'2023-09-01')'''
sql_select='''SELECT TOP 100 * FROM D_Customer WITH(NOLOCK)'''
try:
    cursormssql.execute(sql_insert)
    # python中DML操作需要提交事务
    conmssql.commit()
    cursormssql.execute(sql_select)
    result=cursormssql.fetchall()
    for i in result:
        print(i)
except BaseException as errorm:     #抛出错误原因
    #如果发生错误则回滚
    cursormssql.rollback()
    print("error:",errorm)
#关闭coursor
cursormssql.close()
#关闭连接数据库
conmssql.close()