Register.html:
<html dir="rtl">
<head>
</head>
<body bgcolor="#4169E1" vlink="blue" alink="blue">
<br><br><br><br>
<form action="
http://localhost/try/checkRegister.asp" method="post" name="register">
<table bgcolor="#6495ED" align="center" border="2" width="300" cellpadding="8">
<tr>
<td align="right" nowrap>
<br>
<font size="6" face="areal" onMouseOver=color="#F5F5F5" onMouseOut=color="black">
<b>
<p align="center">
טופס הרשמה
</p>
</b>
</font>
<br><br>
שם משתמש:
<input type="text" maxlength="12" size="18" name="userId">
<br>
סיסמה:
<input type="password" maxlength="12" size="18" name="password">
<br><br>
<div align="center">
<input type="reset" value="נקה"/>
<input type="submit" value="שלח"/>
</div>
</td>
</tr>
</table>
</form>
</body>
</html>
checkRegister.asp:
<html>
<head>
</head>
<body bgcolor="#4169E1">
<%
dim id = Request.Form("userId")
dim pass = Request.Form("password")
dim conn = Server.CreateObject("ADODB.Connection");
dim SQLstr;
conn.Open "myDSN" // פתחתי את זה במקורות נתונים
SQLstr = "INSERT INTO members (ID, PASSWORD) VALUES (" & "'" & "Admin" & "'" & "," & "'" & "Admin" & "')"; // השורה הזאת בטוח נכונה
conn.Execute SQLstr
conn.Close
Set conn = Nothing
%>
</body>
</html>
table name - members, it have 2 fields: ID, PASSWORD, they both text
הודעת השגיאה:
You are not authorized to view this page
You do not have permission to view this directory or page using the credentials you supplied.Please try the following:
- Click the Refresh button to try again with different credentials.
- If you believe you should be able to view this directory or page, please contact the Web site administrator by using the e-mail address or phone number listed on the localhost home page.
HTTP 401.3 - Access denied by ACL on resource
Internet Information Services
Technical Information (for support personnel)
אשמח אם תעזרו לי עם הבעיה, תודה רבה לעוזרים.