OleDbDataAdapter.Fill Error ("The provider could not determine the Object value) ADODB.Recordset

  • Thread starter Thread starter DJ Smith
  • Start date Start date
D

DJ Smith

Hi,

I am trying to fill a DataSet using an ADODB.recordset:

OleDBDataAdapter.Fill(DataSet, Recordset, "Table1")

This works fine in most part but on other occasions I get the error
below:

"The provider could not determine the Object value. For example, the
row was just created, the default for the Object column was not
available, and the consumer had not yet set a new Object value."

This seems to be a data issue, as when the recordset is empty then no
error occurs but the the fields are correct in the DataSet.

What does this error mean and are there any ways around it?

Help is appreciated,
Leroy.
 
Back
Top