title: ASP USER LOGIN SCRIPT
body: <p>When i try to login with the below code it give me an error saying </p>
  
  <blockquote>
    <p>Microsoft JET Database Engine error '80040e10'.</p>
    
    <p>No value given for one or more required parameters.</p>
    
    <p>/ghbet/login2.asp, line 11</p>
  </blockquote>
  
  <p>LOGIN1.ASP:</p>
  
  <pre><code>&lt;html&gt;
      &lt;head&gt;
      &lt;/head&gt;
      &lt;body&gt;
          &lt;table align=center&gt;
              &lt;tr&gt;
                  &lt;td align=center&gt;
                      &lt;b&gt; LOGIN &lt;/b&gt;
                      &lt;br&gt;
                      &lt;br&gt;
                      &lt;br&gt;
                      &lt;form action=login2.asp method=post&gt;
                          UserName &lt;input type=text name=uname /&gt; &lt;br&gt;
                          Password &lt;input type=password name=password /&gt; &lt;br&gt;&lt;br&gt;
                          &lt;p align=right&gt; &lt;input type=submit value=LOGIN name=submit /&gt; &lt;/p&gt;
                  &lt;/td&gt;
              &lt;/tr&gt;
          &lt;/table&gt;
          &lt;/form&gt;
      &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <p>LOGIN2.ASP:</p>
  
  <pre><code>&lt;%
      dim name, pass
      name=Request.form("uname")
      pass=Request.form("password")
  
      set conn=server.CreateObject("ADODB.connection")
      conn.ConnectionString="provider=Microsoft.jet.OLEDB.4.0;data source=C:\Inetpub\wwwroot\ghbet\ghbet.mdb"
      conn.Open
      set rs=Server.CreateObject("ADODB.recordset")
      query="select * from ghbet_users where username='" &amp; name &amp; "'and password='" &amp; pass &amp; "'"
      rs.Open query,conn
  
      if not rs.EOF  then 
          Response.Write " &lt;h4&gt; LOGIN SUCCESSFUL &lt;/h4&gt;"
      else
          response.Write "&lt;h4&gt; USER NAME &amp; PASSWORD NOT MATCHING &lt;/h4&gt;"
      end if
  
  %&gt;vb
  </code></pre>
  
  <p>please help</p>