Microsoft VBScript 编译器错误 错误 '800a03f6'

[dong7765]

Microsoft VBScript 编译器错误 错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'

[Microsoft][ODBC Microsoft Access Driver] 操作必须使用一个可更新的查询。

/test/test.asp，行11

如何解决？

本人是ASP新手
msn:[e-mail]
qq:178704837

[luluso]

数据据那部份错了。贴代码,不QQ.

[dong7765]

<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("data.mdb")

username = "·çÔÆÍ»±ä"
usermail = "[e-mail]"
indate = Now()

sql = "insert into data (username,usermail,indata) values('"&username&"','"&usermail&"',"&indate&")"
'sql = "insert into data (username,usermail) values('"&username&"','"&usermail&"')"
'sql="select username,usermail from data"
conn.Execute(sql)

conn.Close
Set conn = Nothing
%>

[dong7765]

Microsoft VBScript 编译器错误 错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'

[Microsoft][ODBC Microsoft Access Driver]常见错误 不能打开注册表关键字 'Temporary (volatile) Jet DSN for process 0x868 Thread 0x910 DBC 0x17b1024 Jet'。

/test/test.asp，行3

好像是把注册表的OLE DB Provider 删了, 哪儿有下载