别整DW,什么都不用设置,直接写数据库连接代码!
db=Server.MapPath("数据库相对路径")
set conn=Server.CreateObject("ADODB.connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & db
set rs=server.createobject("adodb.recordset")
sql="select * from [表单] order by ID DESC"
rs.open sql,conn,1,1
if err.number <> 0 then
response.write "数据库操作失败:"&err.description
response.end
end if
if RS.eof and RS.bof then
response.write "没有记录!"
response.end
end if
Do While Not rs.EOF
字段1=rs("字段1")
字段2=rs("字段2")
rs.MoveNext
loop
rs.close
set rs=Nothing
Conn.close
set Conn=Nothing
应该是在OBDC创建数据源的时候创建到用户DNS去了,试试在系统DNS里创建