Databases again

Printable View

Jun 30th, 2001, 02:04 PM
Wynd

Databases again
I am trying to make a simple login script with the names and passes stored in an Acces 2000 database. It was working fine before, but now when I go to the page I get this:

Code:

Microsoft OLE DB Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. /auth.asp, line 15

Here is the code:
VB Code:
```
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("logins.mdb"))
 
sSQL = "SELECT Name, Password FROM np"
Set oRS = oConn.Execute(sSQL) ' This is line 15
```
The strange thing was that this was working fine a few minutes ago.
Jun 30th, 2001, 02:36 PM
monte96

Try this:

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("logins.mdb")

Read this from MSDN for more details on why.
Jun 30th, 2001, 02:45 PM
Wynd

1 Attachment(s)

Well, when i use that line it works, but I can't log in. I'm not sure what I am doing wrong. I am typing the names and passes just like in the database. I attached all the .asp files and the database.
Jun 30th, 2001, 08:29 PM
monte96

Change the code in your Auth.asp page to this:

Code:

<% Option Explicit Dim oConn Dim oRS Dim sSQL Dim sTitle Dim sBody Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("logins.mdb")) sSQL = "SELECT Name, Password FROM np where Name='" & Request.Form("Name") & "' and Password='" & Request.Form("Pass") & "'" Set oRS = oConn.Execute(sSQL) If Not (oRS.EOF And oRS.BOF) Then sTitle = "Thanks for logging in" sBody = "Now logged in!<br><br><a href='logout.asp'>Log Out</a>" Else sTitle = "Login Failed" sBody = "Name and password do not match.<br>Please try again." End If oConn.Close Set oRS = Nothing Set oConn = Nothing %> <html> <head> <title><%=sTitle%></title> <style> body { font-family: verdana, arial, helvetica; font-size: 12px; } </style> </head> <body> <%=sBody%> </body> </html>

No need to loop through the database. That would take too much time if you had alot of users. Just retrieve the records if they match. And if you have a match, then they are in.
Jul 2nd, 2001, 04:15 PM
Wynd

Good point. Thanks, you helped a lot.