Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)

[keithhiap]

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria
expression.
/index.asp, line 35

i have following many forums on how to solve this issue. but it still dont work
i suppose t he solution is remove extra ("")
but i dont see any place to remove it, cause i am not a programmer that why
using macromedia to assist me to do my school project. and i am in the rush for
submittion, and is all stuck now.

please help me by reviewing below build in code.

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/conlogindb.asp" -->
<%
Dim Recordset
Dim Recordset_numRows

Set Recordset = Server.CreateObject("ADODB.Recordset")
Recordset.ActiveConnection = MM_conlogindb_STRING
Recordset.Source = "SELECT * FROM login_table"
Recordset.CursorType = 0
Recordset.CursorLocation = 2
Recordset.LockType = 1
Recordset.Open()

Recordset_numRows = 0
%>
<%
' *** Validate request to log in to this site.
MM_LoginAction = Request.ServerVariables("URL")
If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" +
Server.HTMLEncode(Request.QueryString)
MM_valUsername=CStr(Request.Form("username"))
If MM_valUsername <> "" Then
MM_fldUserAuthorization=""
MM_redirectLoginSuccess="register.asp"
MM_redirectLoginFailed="login_error.asp"
MM_flag="ADODB.Recordset"
set MM_rsUser = Server.CreateObject(MM_flag)
MM_rsUser.ActiveConnection = MM_conlogindb_STRING
MM_rsUser.Source = "SELECT username, password"
If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source &
"," & MM_fldUserAuthorization
MM_rsUser.Source = MM_rsUser.Source & " FROM login_table WHERE username='" &
Replace(MM_valUsername,"'","''") &"' AND password='" &
Replace(Request.Form("password"),"'","''") & "'"
MM_rsUser.CursorType = 0
MM_rsUser.CursorLocation = 2
MM_rsUser.LockType = 3
MM_rsUser.Open
If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then
' username and password match - this is a valid user
Session("MM_Username") = MM_valUsername
If (MM_fldUserAuthorization <> "") Then
Session("MM_UserAuthorization") =
CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization ).Value)
Else
Session("MM_UserAuthorization") = ""
End If
if CStr(Request.QueryString("accessdenied")) <> "" And false Then
MM_redirectLoginSuccess = Request.QueryString("accessdenied")
End If
MM_rsUser.Close
Response.Redirect(MM_redirectLoginSuccess)
End If
MM_rsUser.Close
Response.Redirect(MM_redirectLoginFailed)
End If
%>

[Chris In Madison]

What are the data types for each of the fields in login_table, and what kind
of database is it? Sounds like one of the fields in the table may be set to
an incompatible type.

Best regards,
Chris

[keithhiap]

my datatype is

username - text
password - number

everything remain default in Microsoft Access

please help me, my project submission is round the corner, and i have to
complie documentation and presentation.

i am trying out using frontpage, since Macromedia unable to provide a solution.

i have done one similar project before, and has no problem.

i suspected is WinXP SP2, but i formated my computer and try out with patches,
and it still dont work.

is the problem lies on Macromedia Dreamweaver MX 7.2 ?

[CMBergin]

No, the problem is with your data types. The error is from the OLE DB
provider. MM's log in user behavior expects both your user name and
password to be text, and treats them as such. This normally isn't a
problem, as a number submitted as text is converted to a number by the
database without you having to do anything. A problem WILL arise if you
submit non-numeric text in your password field. The conversion to a number
will fail.

"keithhiap" <webforumsuser@macromedia.com> wrote in message
news:d0n3m4$ipn$1@forums.macromedia.com...

> my datatype is
>
> username - text
> password - number
>
> everything remain default in Microsoft Access
>
> please help me, my project submission is round the corner, and i have to
> complie documentation and presentation.
>
> i am trying out using frontpage, since Macromedia unable to provide a

solution.

>
> i have done one similar project before, and has no problem.
>
> i suspected is WinXP SP2, but i formated my computer and try out with

patches,

> and it still dont work.
>
> is the problem lies on Macromedia Dreamweaver MX 7.2 ?
>

[keithhiap]

i converted

username - text - format
password - text - format

and it works

thanks.

however, what i know is when doing declaration, number format is mend for
password, and i never come across password has to set to text format.

ah, i dont give a damn now, i got to rush my project with this solution

[Chris In Madison]

That was going to be my suggestion. Glad you got it working :-)

Best regards,
Chris