var conn,sql; var conn=server.createobject("ADODB.connection"); con.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=testweb"); sql = "insert into test(activeid,userid,chrtel) ("+activeid+","+userid+",'"+mobile+"')"; var rs=server.createobject("adodb.recordset"); rs.open(sql,conn,1,3);