[ASP] Connessione database access 2003

[p73]

Scusate ...forse sto diventando pazzoide VVoVe: VVoVe: VVoVe:

...ho una semplice pagina per effettuare il login così creata:

----------------------------------------------------------------------
<%
If Request.QueryString("step") = "OK" THEN
username = Replace(Request.Form("nome_utente"), "'", "''")
password = Replace(Request.Form("password"), "'", "''")
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};Dbq="&Server.MapPath("mdb-database\database.mdb")
sql = "SELECT ID FROM utenti WHERE USERNAME='" &username & "' AND PASSWORD='" &password& "'"
Set rs = conn.Execute(sql)
if rs.eof then
autenticato = false
else
autenticato = true
end if
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing

if autenticato = true then
Session("Autenticato") = "OK"
Response.Write("OK")
else
Response.Write("non sei autorizzato")
end if
end if
%>

<p align="center">
<form method="post" action="login.asp?step=OK">
Username
<input type="text" name="username">
Password
<input type="password" name="password">
<input type="submit" value="Login">
</form>
</p>
----------------------------------------------------------------------
...bè...il server mi da quest'errore

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/login.asp, line 9

..ma dovè l'errore?

[Roby_72]

sql = "SELECT ID FROM utenti WHERE USERNAME='" &username & "' AND PASSWORD='" &password& "'"
response.write sql:response.end

Cosa vedi a video???

Roby

[santino83_11_04]

AND [PASSWORD]='"....