我想通过javascript向sql数据库中插入数据,却总是无法实现,一下是代码,请各位老师指正: var conn = new ActiveXObject("ADODB.Connection");
conn.connectionString = "Driver={SQL Server};Server=.;Database=线路身份证";
conn.open;
var sql ="insert into 线路缺陷(电压等级,巡视日期) values('110kV','2012-2-2')";
conn.execute(sql);
conn.close();
return false;
conn.connectionString = "Driver={SQL Server};Server=.;Database=线路身份证";
conn.open;
var sql ="insert into 线路缺陷(电压等级,巡视日期) values('110kV','2012-2-2')";
conn.execute(sql);
conn.close();
return false;
<%
var conn = new ActiveXObject("ADODB.Connection");
conn.ConnectionString = "Driver={SQL Server};Server=.;Database=线路身份证;Uid=用户名;Pwd=密码";
conn.Open();
if (conn.state!=1){
resoinse.write("数据库没连上啊!换OLE DB方式再试试吧");
conn=null;
response.end();
} var sql ="insert into 线路缺陷(电压等级,巡视日期) values('110kV','2012-2-2')";
conn.Execute(sql);
conn.Close();
return false;
%>