#12004/12/1 22:42:50
本人想向数据库中插入数据,但是总是无法成功!
找了好久也没有找到错误在那!希望大虾 能帮个忙!源代码如下:::
--------------------------------------------------------------------------------------------------------------
<%Set conn = Server.CreateObject("ADODB.Connection")
conn.open("DRIVER={Microsoft Access Driver (*.mdb)}; " & "DBQ=" & Server.MapPath("/store/good.mdb"))
sql = "insert into [book] (qq,text) values('123','456')"
conn.Execute(sql)
conn.Close
Set conn = Nothing
%>
错误代码如下:::
-------------------------------------------------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/New/untitled.asp,行 4