What does the following exception mean?

K

Khaledinho

Active member
Joined
Jun 22, 2005
Messages
25
Hi

Can anybody explain why the following exception occurs

Microsoft OLE DB Provider for SQL Server error 80040e10

No value given for one or more required parameters.

/somepage.asp line 22;
 
In other words a stored procedure (or function) was expecting a parameter to be passed to it and one wasnt.
 
It can also mean a typo when entering a SQL statement
eg
Select * From [Mytable] where [Mytalbe].[GroupID]=10

because the Mytable is spelt incorrectly in the where clause the parser sometimes assumes that it is expecting a paramter, though my experience with this particular exception has been when using MS Access Dbs
 
Back
Top