Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 28-08-2009
Member
 
Join Date: Jun 2009
Posts: 105
Error '80040e10' Too few parameters

I have created a database created in Microsoft Access 2007. I am getting the below error message.

Quote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access 2007 Driver] Too few parameters. Expected 1.
Customer/ASP Page8.asp, line 397
What does this mean? I have checked line 397 and it seems to me perfectly OK. Then where is the problem? Can you tell me why I am getting error '80040e10'?
Reply With Quote
  #2  
Old 28-08-2009
Member
 
Join Date: Nov 2008
Posts: 1,054
Re: Error '80040e10' Too few parameters

This error occurs when you specify one of the column names in a SELECT statement that does not exist in the table being queried. The only expected solution to this is remove any invalid column names from the SELECT statement.
Reply With Quote
  #3  
Old 28-08-2009
Member
 
Join Date: Apr 2008
Posts: 2,001
Re: Error '80040e10' Too few parameters

This kind if errors occurs if you have a field name which is misspelled; or you forgot to mention some parameter values; or you tried to insert the wrong datatype. To troubleshoot this, make sure you have some data for all parameters with proper datatype and reconfirm if they are correctly mentioned.
Reply With Quote
  #4  
Old 28-08-2009
Member
 
Join Date: May 2008
Posts: 2,383
Re: Error '80040e10' Too few parameters

Try one of the following solutions:

1) Reconfirm if you have the correct ADODB driver and not the Jet driver. The first is made for Access while other is for SQL.

2) Reconfirm you close all your ADODB objects when you don't require them.

3) Reconfirm if the field's case in your query matches as that of in your database.

4) You can even repair your database to solve any other problems.
__________________
The FIFA Manager 2009 PC Game
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Error '80040e10' Too few parameters"
Thread Thread Starter Forum Replies Last Post
How to fix ?Failed to set write parameters. Reason Invalid field in parameter list? error message on ImgBurn? Manthan G Windows Software 3 25-03-2012 10:16 AM
URL dynamic parameters Bricklayer Software Development 6 02-08-2010 10:30 AM
VBA Recordset / Parameters Gunner 1 Software Development 5 17-02-2010 12:38 AM
Database Error: Too few parameters. Expected 5 KALIDA Software Development 2 31-08-2009 11:50 PM
error usb (exception processing message c0000013 parameters 75b1bf7c 4 75b1bf7c 75b1bf7c) IndrneeL Windows XP Support 1 24-12-2008 03:31 AM


All times are GMT +5.5. The time now is 06:40 PM.