OleDBDataAdapter Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a dataAdapter to a Access .mdb file. When I check the data connection the adapter displays it could not return data from the source
No value given for one or more required paramaters. Where and How do I fix this?
 
best guess - look at its SelectCommand (which has question marks for
parameters in it) and Parameters (each of which corresponds to a ? in
SelectCommand)
It's probably some mismatch between the two or between the query and
your MDB's schema
 
Hi Homey,

Did you do it by code or with the dataadapter wizard (which I asume)

There are tow kind of dataadapters for Access (OleDB, ODBC)

Which one did you use.

They behave diferent, what did you use as first question?

Cor
 
¤ I have set up a dataAdapter to a Access .mdb file. When I check the data connection the adapter displays it could not return data from the source.
¤ No value given for one or more required paramaters. Where and How do I fix this?

You probably have one or more column names that are misspelled. It might help us diagnose the
problem if you could post your code.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top