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.
-------------------------------------------------------------------------------- |
|
|