请各位大哥帮我看下错在哪里了。谢谢呀

来源:百度知道 编辑:UC知道 时间:2024/05/07 06:27:00
<%
dim xm,zjys,year3,month3,day3,year4,month4,day4,date3,date4,date5
xm=request("xm")
zjys=request("zjys")

year3=request("year3")
month3=request("month3")
day3=request("day3")

year4=request("year4")
month4=request("month4")
day4=request("day4")

date3=request("year3") & "/" & request("month3")& "/" &request("day3")
date4=request("year4") & "/" & request("month4")& "/" &request("day4")

dim conn,connstr,date1,date2
on error resume next
connstr="DBQ="+server.mappath("db1.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
Set conn=Server.CreateObject("ADODB.CONNECTION")
conn.open connstr

'response.write(month(date))

'response.

把connstr="DBQ="+server.mappath("db1.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
Set conn=Server.CreateObject("ADODB.CONNECTION") 改为:
db="db1.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")或:
Set conn = Server.CreateObject("ADODB.Connection")
connstr"driver={microsoft access driver (*.mdb)};dbq="&server.mappath("db1.mdb")

你运行啊 出错会提示你