Error 80040e07

Results 1 to 2 of 2

Thread: Error 80040e07

  1. #1
    Raymond Guest

    Default Error 80040e07

    Line 83 is the SET Rs = Line, any help?<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e07&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. <BR><BR>/insert.asp, line 83<BR><BR>set conn = server.createobject("adodb.connection")<BR>conn.op en "DSN=nfdicust"<BR>SQLstmt = "INSERT INTO customer (First,Last,Company,Title,Address,Address2,City,St ate,Zip,Phone,Fax,Email,MailList,Access,Password)" <BR>SQLstmt = SQLstmt & " VALUES (" <BR>SQLstmt = SQLstmt & "&#039" & First & "&#039,"<BR>SQLstmt = SQLstmt & "&#039" & Last & "&#039,"<BR>SQLstmt = SQLstmt & "&#039" & Company & "&#039,"<BR>SQLstmt = SQLstmt & "&#039" & Title & "&#039,"<BR>SQLstmt = SQLstmt & "&#039" & Address & "&#039,"<BR>SQLstmt = SQLstmt & "&#039" & Address2 & "&#039,"<BR>SQLstmt = SQLstmt & "&#039" & City & "&#039,"<BR>SQLstmt = SQLstmt & "&#039" & State & "&#039,"<BR>SQLstmt = SQLstmt & "&#039" & Zip & "&#039,"<BR>SQLstmt = SQLstmt & "&#039" & Phone & "&#039,"<BR>SQLstmt = SQLstmt & "&#039" & Fax & "&#039,"<BR>SQLstmt = SQLstmt & "&#039" & Email & "&#039,"<BR>SQLstmt = SQLstmt & "&#039" & MailList & "&#039,"<BR>SQLstmt = SQLstmt & "&#039" & Access & "&#039,"<BR>SQLstmt = SQLstmt & "&#039" & Password & "&#039"<BR>SQLstmt = SQLstmt & ")"<BR><BR>Set RS = conn.execute(SQLstmt)<BR>

  2. #2
    Peter L Guest

    Default RE: Error 80040e07

    What if you did a response.write SQLstmt and see what returns to your browser.. Easier to debug

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •