ODBC Drivers error 80040e57

Results 1 to 3 of 3

Thread: ODBC Drivers error 80040e57

  1. #1
    John Magnus Guest

    Default ODBC Drivers error 80040e57

    I&#039;ve got a really big problem (at least it&#039;s to me). I would really appreciate some help as I haven&#039;t got a clue why this doesn&#039;t work... I&#039;m trying to fetch some specific data from my database, but the code I&#039;ve written only works on my local machine (Access/PWS) not on the server (Access/IIS). I have no idea of what&#039;s going on... (Other functions works just fine!)<BR><BR>&#039; ***COMMAND*** &#039;<BR>SqlCommand = _<BR> & "SELECT * FROM News"_<BR> & " WHERE Approved=True"_<BR> & " AND Value1&#060;" & TestValue_<BR> & " AND Value2&#062;" & TestValue_<BR> & " ORDER BY Value1 ASC, Value2 DESC;"<BR><BR>Set dbCommand1 = Server.CreateObject ("ADODB.Recordset")<BR>Set dbCommand1 = dbConnection.Execute (SqlCommand)<BR><BR>&#039; ***ERROR*** &#039;<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80040e57&#039;<BR>[Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null)<BR>/_inc/common.asp, line 105

  2. #2
    Join Date
    Dec 1969

    Default RE: ODBC Drivers error 80040e57

    Do a "response.write SqlCommand" right after creating the SQL statement. I bet one of the values is null. <BR><BR>Also, WHERE approved=True should be WHERE approved=&#039;True&#039; if approve is character field.

  3. #3
    John Magnus Guest

    Default RE: ODBC Drivers error 80040e57

    Good tip! I tested it, and all variables held (legal) values, ie the SqlCommand holds the right values. (Approved is a Yes/No field...) Thanks anyway!

Posting Permissions

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