请问如何向ADO数据中写入信息
以下方法我在自己的Win2000+IIS上没问题,可一上传到服务器上就不行,怎么回事?
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("data.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
sql="Insert Into TableName (a,b,c,d,e,f) Values("
sql=sql & SqlStr(Thea) & ","
sql=sql & SqlStr(Theb) & ","
sql=sql & SqlStr(Theb) & ","
sql=sql & SqlStr(Thed) & ","
sql=sql & SqlStr(Thee) & ","
sql=sql & SqlStr(Thef) & ")"
conn.Execute sql
conn.Close
Set conn=Nothing
Response.Redirect "xxx.asp"
经验正就是执行到conn.Execute sql 时出错,这是为何??