What does the following exception mean?

[Khaledinho]

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;

[bri189a]

In other words a stored procedure (or function) was expecting a parameter to be passed to it and one wasn't.

[Afraits]

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