no value given for one or more parameters

[Guest]

Hi,

I know there are a couple of other posts regarding this matter, but I am
using the simplest of statements, yet the get the above error. My code looks
like this:

OleDbCommand cmd = new OleDbCommand ("SELECT Name FROM Employees", Conn);
conn.Open();
OleDbDataReader dr = cmd.ExecuteReader();

It falls over on the ExecuteReader with the above error (I have the actual
code in a try catch block, calling the Read method of dr).

As I am not specifying any parameters, can anyone tell me what the problem
might be?

 

[Scott M.]

You are specifying a parameter: "Name". This message indicates that there
is no such field in the database called "Name".

 

[William \(Bill\) Vaughn]

"Name" is a reserved word. Either rename the column or use [Name]

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________