DataAdapter Fill Exception

  • Thread starter Thread starter Fla
  • Start date Start date
F

Fla

Good Morning.
I get the following exception when I try to store the content of a
Microsoft Database (.MDB File) in a table, with DbDataAdapter.Fill
method.

System.InvalidOperationException: 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. at System.Data.OleDb.ColumnBinding.Value()

The stack-trace of the exception is the reported below:

System.InvalidOperationException: 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. at System.Data.OleDb.ColumnBinding.Value() at
System.Data.OleDb.OleDbDataReader.GetValues(Object[] values) at
System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues
(Object[] values) at System.Data.ProviderBase.SchemaMapping.LoadDataRow
() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping
mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet
dataset, DataTable datatable, String srcTable, DataReaderContainer
dataReader, Int32 startRecord, Int32 maxRecords, DataColumn
parentChapterColumn, Object parentChapterValue) at
System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill
(DataSet dataSet)

Does anyone could give me any advice?

Thanks in advance
 
Jet shouldn't be used with .NET because it isn't support natively on
X64
 
If you want help debugging code, you should probably post at least a
snippet so people can see what you're trying to do. A stack trace
isn't much use if you have no idea which line of code caused it.

--Mary
 
Sounds like you tried to append a record where a field was required, a field
not allowing null, a field designed without default value, and no value was
specified by your code for that field.


Vanderghast, Access MVP
 
Back
Top