OLEDB error '80040e10'

Results 1 to 4 of 4

Thread: OLEDB error '80040e10'

  1. #1
    Kate Guest

    Default OLEDB error '80040e10'

    Today the following code produces an error :<BR>_________________________<BR>Dim mainConn<BR>Set mainConn = Server.CreateObject("ADODB.Connection")<BR>mainCon n.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};"&"DBQ=D:InetpubPlantsDBplants.mdb"<BR>ma inConn.Open <BR><BR>Dim mainObj<BR>Set mainObj = Server.CreateObject("ADODB.Recordset")<BR>mainObj. Open strQuery, mainConn<BR>________________________<BR>...yesterd ay it didn&#039;t. (I moved it from one folder to another, along with its database)<BR><BR>the error it produces is :<BR>________________________<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80040e10&#039; <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3. <BR><BR>/PlantsDB/plants.asp, line 46 <BR>________________________<BR>...so today it wants 3 parameters. I only give it 2. Yesterday, 2 was enough. Why has it become greedy ?<BR><BR>Many thanks,<BR><BR>Kate<BR><BR>

  2. #2
    Kate Guest

    Default RE: OLEDB error '80040e10'

    OK, now it&#039;s objecting - it wants 4 parameters !!! please help

  3. #3
    Join Date
    Dec 1969

    Default RE: OLEDB error '80040e10'

    Kate....<BR><BR>I need to see what is in your strQuery variable. <BR><BR>Are you doing an INSERT Statement? Sounds like an INSERT with incorrect variable/field pairs<BR><BR>Robert

  4. #4
    Kate Guest

    Default RE: OLEDB error '80040e10'

    That&#039;s OK - thankyou, I didn&#039;t realise I should be looking for an SQL error - I looked for one and found it ! Cheers,<BR>Kate

Posting Permissions

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