|
#2
hu9jj2013-01-01 09:21
|
如下ASP代码有误：
<html>
<head>
<title>MDB Data Write Sample</title>
</head>
<body>
</body>
</html>
<%
Dim Conn,RS,RS2,RS3,RS4,RS5,RS6,RS7
Set Conn = Server.CreateObject('ADODB.Connection')
Conn.Provider = 'Microsoft.Jet.OLEDB.4.0'
Conn.Open '\Stu.mdb' //数据库为该页根目录下的Stu.mdb
//插入数据
Set RS = Conn.Execute(INSERT into Stu VALUES(STU_01,'司马懿))
Set RS2 = Conn.Execute(INSERT into Stu VALUES(STU_02,'诸葛亮'))
Set RS3 = Conn.Execute(INSERT into Stu VALUES(STU_03,'曹操'))
Set RS4 = Conn.Execute(INSERT into Stu VALUES(STU_04,'大乔'))
Set RS5 = Conn.Execute(INSERT into Stu VALUES(STU_05,'黄月英'))
Set RS6 = Conn.Execute(INSERT into Stu VALUES(STU_06,'貂婵'))
//查询数据
Set RS7 = Conn.Execute(Select * From Stu)
//显示RS7
Response.Write RS7 <BR>
Response.Write "数据操作 已完成"
Conn.Close
%>
错误为Syntax Error，错误句为Set Conn = Server.CreateObject('ADODB.Connection')
怎么回事？