F
forjing_888
Unregistered / Unconfirmed
GUEST, unregistred user!
<%
id=request("id")
password=request("password")
ok=session("checkok")
if ok<>"yes" then
set cnobject=server.createobject("adodb.connection")
dbpath=server.mappath("image1.mdb")
cnobject.open "driver={Microsoft Access Driver (*.mdb)};pwd=1234;dbq="&dbpath
set recobject=server.createobject("adodb.recordset")
sql="select * from db1 where id='" &
id &"'"
sql= sql &
" and password='" &
password &
"'"
recobject.open sql,cnobject,1,1,1
if not recobject.eof then
ok="yes"
session("checkok")=ok
else
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-tw">
<meta http-equiv="Content-Type" content="text/html;
charset=big5">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>新網頁1</title>
</head>
<body background="bj1.gif">
<h2 align="center"><img src="log.gif"></h2>
<center>
<form action=<%request.servervariables("path_info")%> method=post>
<table border=1 cellspacing=0>
<tr>
<td><align=right>登入名稱：</td>
<td><input type=text name=id size=20></td>
</tr>
<tr>
<td><align=right>登入密碼：</td>
<td><input type=text name=password size=20></td>
</tr>
</table><p>
<input type=submit value="確定">
</form>
</center>
</body>
</html>
<%
response.end
end if
end if
%>
ODBC驅動已經裝了，不知道錯在哪里！
IE提示如下錯誤：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC driverdo
es not support the requested properties.
//login.asp, line 12
估計是這句錯了，可是我改不好
recobject.open sql,cnobject,1,1,1
請好心人幫我解決一下！
id=request("id")
password=request("password")
ok=session("checkok")
if ok<>"yes" then
set cnobject=server.createobject("adodb.connection")
dbpath=server.mappath("image1.mdb")
cnobject.open "driver={Microsoft Access Driver (*.mdb)};pwd=1234;dbq="&dbpath
set recobject=server.createobject("adodb.recordset")
sql="select * from db1 where id='" &
id &"'"
sql= sql &
" and password='" &
password &
"'"
recobject.open sql,cnobject,1,1,1
if not recobject.eof then
ok="yes"
session("checkok")=ok
else
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-tw">
<meta http-equiv="Content-Type" content="text/html;
charset=big5">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>新網頁1</title>
</head>
<body background="bj1.gif">
<h2 align="center"><img src="log.gif"></h2>
<center>
<form action=<%request.servervariables("path_info")%> method=post>
<table border=1 cellspacing=0>
<tr>
<td><align=right>登入名稱：</td>
<td><input type=text name=id size=20></td>
</tr>
<tr>
<td><align=right>登入密碼：</td>
<td><input type=text name=password size=20></td>
</tr>
</table><p>
<input type=submit value="確定">
</form>
</center>
</body>
</html>
<%
response.end
end if
end if
%>
ODBC驅動已經裝了，不知道錯在哪里！
IE提示如下錯誤：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC driverdo
es not support the requested properties.
//login.asp, line 12
估計是這句錯了，可是我改不好
recobject.open sql,cnobject,1,1,1
請好心人幫我解決一下！