123 Eng

Engineering the engineers™


Latest Jobs   Forum Map

 


Home

Source Codes

Engineering Colleges

BE Students

Training  Reports (updated)

Seminar Reports (updated

Placement Papers (updated)

Forums

   Computer Science / IT

   Electronics

   Electrical

   Mechanical

   Chemical

   Civil

   CAT / MBA

   GMAT / Foreign MBA

Latest Jobs

Engineering Jobs / Technical Jobs

Management Jobs

Sitemap

About-Us

Terms of use

Displaying  Source Code(s)  
 

 
Why do I get 80040E10 errors?

--------------------------------------------------------------------------------



When creating SQL statements in ASP, you might encounter one of the following errors:

@CODETABSTART
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
or
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected <n>.
or
Microsoft OLE DB Provider for SQL Server error '80040e10'
Procedure '<procedure>' expects parameter '<param>', which was not supplied.
@CODETABEND

This error is due to one of the following things:
1. A field name was spelled incorrectly.
2. One or more of the values was blank.
3. You tried to insert the wrong datatype (e.g. surrounded a numeric value with quotes).

To troubleshoot this, response.write your SQL statement... make sure there is data for all params you are passing,
and compare field names directly with those in the table. Also copy this SQL statement and execute it directly in the
database, if the error message and the response.write statement aren't already giving you enough information.

--------------------------------------------------------------------------------

 

 

Contribute content or training reports / feedback / Comments
job placement papers
All rights reserved © copyright 123ENG