为什么很简单的asp表单insert一记录到库里在本机的iis下通过，可一上传到服务器上就出错呢，急啊，给分100

[ejie_02]

function sqlstr(data)
sqlstr="'"&replace(data,"'","''")&"'"
end function

set conn=server.createobject("ADODB.connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&server.mappath("manage/ly/ly.mdb")
sql="insert into ly(姓名,电话,电子邮件,城市,省份,问题,客户IP,时间,日期) values("&sqlstr(name1)&","&sqlstr(telephone1)&","&sqlstr(email1)&","&sqlstr(city1)&","&sqlstr(province1)&","&sqlstr(question1)&","&sqlstr(ip)&","&sqlstr(time1)&","&sqlstr(date1)&")"
conn.execute sql

----------------------------------------------------------------------
出错信息:

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

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

[孟子E章]

PRB：错误信息：0x80004005:General Error Unable to Open Registry Key（出现常规错误，无法打开注册表项）

http://support.microsoft.com/kb/295297/zh-cn

[孟子E章]

http://www.google.com/search?hl=zh-CN&newwindow=1&q=%5BMicrosoft%5D%5BODBC+Microsoft+Access+Driver%5D%E5%B8%B8%E8%A7%81%E9%94%99%E8%AF%AF+%E4%B8%8D%E8%83%BD%E6%89%93%E5%BC%80%E6%B3%A8%E5%86%8C%E8%A1%A8%E5%85%B3%E9%94%AE%E5%AD%97+%27Temporary++Jet%27&btnG=%E6%90%9C%E7%B4%A2&lr=

[hzw66]

可能的原因：数据库文件没有写权限、数据库路径不正确

[hchxxzx]

很可能是你上传到服务器之后,没有在服务器上设置ly.mdb文件的权限,你必须设置iusr_机器名 这个用户以"修改"权限.

[annyking]

数据库地址不对，晕倒