OleDBDataAdapter Question

[Homey]

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?

[Uri Dor]

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

Homey wrote:

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?

[Cor]

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

[Paul Clement]

On Sat, 28 Feb 2004 18:01:08 -0800, "Homey" <an*******@discussions.microsoft.com> wrote:

¤ 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 ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)