asp mssql向数据库中保存信息

' mssql向中保存信息

Set conn = Server.CreateObject("ADODB.Connection")
strconn="Provider=SQLOLEDB.1;Persist Sercurity Info=True;User ID=sa;PWD=sa;Initial Catalog=database;Data Source=(127.0.0.1)"
conn.open strconn

sql ="insert into datab(url)values('www.111cn.net')";
conn.execute( sql )
response.Write("保存成功"）