ODBC Error ' 80040e10'

Results 1 to 2 of 2

Thread: ODBC Error ' 80040e10'

  1. #1
    Join Date
    Dec 1969

    Default ODBC Error ' 80040e10'

    Pls help me! I kept on getting this error message!<BR><BR>"Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e10&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. "<BR><BR>Sometimes it works, sometimes it doesn&#039t. What is wrong?<BR>I use either this<BR>"rsItems.Open strSQL, objConn"<BR>or this<BR>"rsItems.Open strSQL, objConn,adOpenForwardOnly , adLockOptimistic, adCmdText"<BR><BR>Pls pls help!!! <BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: ODBC Error ' 80040e10'

    The Error is in your SQL query<BR><BR>do a Response.Write of your SQL statement. You will find that a. either no data is being passed to it, or b. the data is being passed incorrectly. i.e. Date value (in access) not surrounded by # signs, or Text values not surrounded by quotes.<BR><BR>let me know if that helps<BR><BR>mj

Posting Permissions

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