为什么我的execute不好使呢?

代码如下:
Dim objCon
Set objCon = Server.CreateObject("ADODB.Connection")
objCon.Open = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=school;Data Source=TY-SORCERER"

strSQL = "insert into student (id,class_id,number,name,uuid,password) values ('1','1','1','小王','1','1') "
objCon.Execute (strSQL)

我想望数据库中添加一条记录,可是总说运行时错误。各位大哥来救小弟了
---------------------------------------------------------------

what error did you get? try to run the SQL statement in Query Analyzer

Published At
Categories with Web编程
Tagged with
comments powered by Disqus