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




On Mar 3, 1:53*am, Fla <fla_gro...@tiscali.it> wrote:
> 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

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

On Tue, 3 Mar 2009 01:53:31 -0800 (PST), Fla <(E-Mail Removed)>
wrote:

>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

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


"Fla" <(E-Mail Removed)> wrote in message
news:a5de29aa-e23f-4a19-89d2-(E-Mail Removed)...
> 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