大家帮忙找下错误吧,谢谢
半天我没弄明白
thestring= "provider=microsoft.jet.oledb.4.0;" & "data source = " & server.mappath("/db_asdfasdlfasdce/db.mdb")
dim id
dim password
dim url
id=request.Form("id")
password=request.Form("password")
url=request.Form("url")
if id = "" or password ="" then
response.Redirect("login.asp")
response.End()
end if
set rs=server.CreateObject("adodb.recordset")
rs.ActiveConnection=thestring
rs.source= "select * from user"
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 1
rs.open()
为什么运行的时候会在这里提示:
Microsoft JET Database Engine (0x80040E14)
FROM 子句语法错误。
/admin/loginchk.asp, 第 22 行
但是改成
thestring= "dsn=datesource;"
就没有问题了,奇怪
烦劳哪位指正一下