No value given for one or more required parameters

[William Gower]

I am getting this error on a line that fills the data adapter object with a
dataset


I have a SQL string that holds the sql statement

Dim da As New System.Data.OleDb.OleDbDataAdapter(strSQL,
strConnection)
da.Fill(ds, "requests")
DGRequests.DataSource = ds

Is the error telling me that I have a mistake in my sql statement?

 

[Jason DeFontes]

Yeah. Access is really bad when it comes to reporting syntax errors in
SQL statements. It thinks anything that it doesn't recognize as valid
table or column name is a parameter to be filled in at runtime (this
makes sense if you've ever done any development directly in Access), but
usually it's a syntax error, or you misnamed a column or something. Set
a breakpoint or print out your SQL statement and take a look and you'll
probably see the error. If not, try pasting it into a query in Access
and running it there, and it should tell you what it thinks is a parameter.

-Jason

 

[Urvish]

Hi All,

I just got the same problem solved.

I was facing same problem with my MS ACCESS database.

The likely reason for that error could be that the field name in WHERE condition doesnt match the case as that of the database.

Regards,
Urvish