OledbCommand queries

  • Thread starter Thread starter Edward Bender
  • Start date Start date
E

Edward Bender

I thought that a parmeterized query to an access database utilized
parameter position and not name. However, I find that I can not get a
successful ExecuteNonQuery() result unless the names of the parameters
added to the oledbcommand.parameters.add("Name", OLEDBType) statements
match the name of the parameter in the access database. Needless to
say, position also is required. Am I getting this wrong or do name in
addition to position matter?
Thanks, E Bender
 
Parameterized query should work even the names of parameters don't match the
column names. Could you share your statement and parameter settings so we
can take a look?

Thanks,
Kevin
 
Back
Top