Re: DataAdapter Fill Exception

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



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 <fla_groups@xxxxxxxxxx>
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
.



Relevant Pages

  • Very strange SQL connection problem
    ... System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ... System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, ... Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.adonet)
  • Databases in sql
    ... the Microsoft 'Developing Web Applications' book, and have got to a bit ... System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, ... Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.languages.csharp)
  • A transport-level error has occurred when receiving results from the server.
    ... asyncResult, TdsParserStateObject stateObj) at ... dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) ... DataTabledatatables, Int32 startRecord, Int32 maxRecords, String ... startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior ...
    (microsoft.public.sqlserver.connect)
  • SQLConnection Help
    ... System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ... System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, ... Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.aspnet)
  • Connection Pooling randomly throwing exceptions
    ... DataTabledatatables, Int32 startRecord, Int32 maxRecords, String srcTable, ... Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ... (Exception from HRESULT: ...
    (microsoft.public.dotnet.framework.adonet)