一个简单问题
asper 2000-08-09 03:54:00 windows2000,Access2000,简单的只有一个字段temp的表test.
<!--#include file="adovbs.inc"--->
<%
dim conn
set conn=server.createobject("adodb.connection")
conn.open "DSN=test1;"
conn.execute "insert test (temp) values('hello')"
conn.close
%>
ie报错
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
/images/test.asp, 第 8 行
<%
dim conn
dim accessdb
dim myDSN
accessdb="db1.mdb"
myDSN="DRIVER={Microsoft Access Driver (*.mdb)};"
myDSN=myDSN&"DBQ="&server.mappath(accessdb)
set conn=server.createobject("adodb.connection")
conn.open myDSN
dim rs
rs=server.createobject("adodb.recordset")
rs.locktype=adlockoptimistic
rs.open "select * from test",conn
rs.addnew
rs("temp")="hello"
rs.update
%>
到rs.update是报类似的错误
//faint我该怎么做呀?