28,390
社区成员
发帖
与我相关
我的任务
分享
function addinfo(ttm, tnum, tdw){
var linkstr;
var myconn = new ActiveXObject("ADODB.Connection");
var rrs = new ActiveXObject("ADODB.Recordset");
var addstr = "insert into mytable(tm,sqnum,sqdw,sqtime) VALUES(ttm,tnum,tdw,DateTime.Now)";
linkstr = "Provider=SQLOLEDB; UID=mydb;PWD=mydb;Data Source=db ;initial catalog=mydb ";
alert(1);
myconn.Open(linkstr);
alert(2);
rrs.open(addstr, myconn, 2, 1);
rrs.close();
rrs = null;
myconn.close();
myconn = null;
}