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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OleDbCommand String & Parameters 1
MS Access, how to update query ??? 2
[Net1.1SP1][OledbCommand] 2
DBConcurrencyException on dataset update (because of datetime primary key ?) 11
OleDbCommand.Parameters.Add and 'IN' Comparator and MSAccess 5
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Parameters in .net (Accessing MS Access) 6
Concurrency control in updating Access records? 4

Back
Top