[Firebird-net-provider] Fill Method of FbDataAdapter fails

[LtColRDSChauhan <rds...@gm...>]

Hi,

I am creating an object of FbDataAdapter, passing the constructor an object
of FbCommand . The CommandText of this FbCommand object is a stored
procedure.

This worked fine. Recently calling Fill method of FbDataAdapter reports
error [appended at the end of mail]. The copied CommandText, during debug,
runs fine in Flamerobin. Also when i change the code to restrict the number
of rows to say 50, it runs fine. Changed this in two ways (both ways it
worked):

(1) In the querry used " SELECT first 50 ... "

(2) Passed arguments to Fill method: da.*Fill*(ds, 0, 50, "Table");


Please help me to fetch all records using Fill method of FbDataAdapter.


THE ERROR reported:

System.IO.IOException: I/O error occurred.

at Byte[] FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes(System.Int32
count)

at Int32 FirebirdSql.Data.Client.Managed.XdrStream.ReadInt32()

at Int32 FirebirdSql.Data.Client.Managed.XdrStream.ReadNextOperation()

at Int32
FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.NextOperation()

at Int32
FirebirdSql.Data.Client.Managed.Version11.GdsDatabase.NextOperation()

at DbValue[] FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()

at DbValue[] FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()

at Boolean FirebirdSql.Data.FirebirdClient.FbDataReader.Read()

at Boolean System.Data.ProviderBase.DataReaderContainer.Read()

at Int32
System.Data.Common.DataAdapter.FillLoadDataRow(System.Data.ProviderBase.SchemaMapping
mapping)

at Int32 System.Data.Common.DataAdapter.FillFromReader(System.Data.DataSet
dataset, System.Data.DataTable datatable, System.String srcTable,
System.Data.ProviderBase.DataReaderContainer dataReader, System.Int32
startRecord, System.Int32 maxRecords, System.Data.DataColumn
parentChapterColumn, System.Object parentChapterValue)

at Int32 System.Data.Common.DataAdapter.Fill(System.Data.DataSet dataSet,
System.String srcTable, System.Data.IDataReader dataReader, System.Int32
startRecord, System.Int32 maxRecords)

at Int32 System.Data.Common.DbDataAdapter.FillInternal(System.Data.DataSet
dataset, System.Data.DataTable[] datatables, System.Int32 startRecord,
System.Int32 maxRecords, System.String srcTable, System.Data.IDbCommand
command, System.Data.CommandBehavior behavior)

at Int32 System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet dataSet,
System.Int32 startRecord, System.Int32 maxRecords, System.String srcTable,
System.Data.IDbCommand command, System.Data.CommandBehavior behavior)

at Int32 System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet dataSet,
System.String srcTable)

at static DataTable HMSLib.Ctrls.DtFromObjArray(System.Object arg)

at static Object HMSLib.Ctrls.DgvDtFromObjArray(System.Object args)

at static System.Void HMSLib.Ctrls.DgvDtProc(System.Object args)

at static System.Void
System.Threading.ThreadHelper.ThreadStart_Context(System.Object state)

at static System.Void
System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext
executionContext, System.Threading.ContextCallback callback, System.Object
state, System.Boolean preserveSyncCtx)

at static System.Void
System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext
executionContext, System.Threading.ContextCallback callback, System.Object
state, System.Boolean preserveSyncCtx)

at static System.Void
System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext
executionContext, System.Threading.ContextCallback callback, System.Object
state)

at System.Void System.Threading.ThreadHelper.ThreadStart(System.Object obj)


Regards,

Rajiv