Bug/Error when assigning to DataTable the IDataReader.GetSchemaTable.

Bug or Error Assigning to DataTable the IDataReader.GetSchemaTable. Used a
OleDbCommand to populate the IDataReader with code:
OleDBCommand.Create('Select * From [' + sOrig + ']', ConnOrig)

There is an error if an MS Access table has a text field size of 254 but 200
works fine.

Exact error: "The data value could not be converted for reasons other than
sign mismatch or data overflow. For example, the data was corrupted in the
data store but the row was still receivable"

Dan
Fri Feb 20 14:13:21 CST 2004

I have the same error again. To get rid of it I have to delete all the rows
from the Access table - but I don't want to do that obviously. But as soon
as I add any data, I get the same error.
Same error if: I compact and repair the database.
Same error if: I delete the table and copy the structure only from a Backup
copy of the table and add some new data and use the same table name.
Same error if: I delete all fields from the table and add a new field and
some new data, but the error is gone if I delete all rows in this one field
table.
Same error if: I rename the table.


"Dan V." <danv@yah.com> wrote in message
news:e73y2u89DHA.2064@TK2MSFTNGP11.phx.gbl...
> Bug or Error Assigning to DataTable the IDataReader.GetSchemaTable. Used
a
> OleDbCommand to populate the IDataReader with code:
> OleDBCommand.Create('Select * From [' + sOrig + ']', ConnOrig)
>
> There is an error if an MS Access table has a text field size of 254 but
200
> works fine.
>
> Exact error: "The data value could not be converted for reasons other than
> sign mismatch or data overflow. For example, the data was corrupted in
the
> data store but the row was still receivable"
>
>

Dan
Fri Feb 20 15:41:05 CST 2004

Ooops my mistake. My error catching was not doing what I expected. Invalid
cast error and missing field name sometimes.


"Dan V." <danv@yah.com> wrote in message
news:uQ2193%239DHA.1936@TK2MSFTNGP12.phx.gbl...
> I have the same error again. To get rid of it I have to delete all the
rows
> from the Access table - but I don't want to do that obviously. But as
soon
> as I add any data, I get the same error.
> Same error if: I compact and repair the database.
> Same error if: I delete the table and copy the structure only from a
Backup
> copy of the table and add some new data and use the same table name.
> Same error if: I delete all fields from the table and add a new field and
> some new data, but the error is gone if I delete all rows in this one
field
> table.
> Same error if: I rename the table.
>
>
> "Dan V." <danv@yah.com> wrote in message
> news:e73y2u89DHA.2064@TK2MSFTNGP11.phx.gbl...
> > Bug or Error Assigning to DataTable the IDataReader.GetSchemaTable.
Used
> a
> > OleDbCommand to populate the IDataReader with code:
> > OleDBCommand.Create('Select * From [' + sOrig + ']', ConnOrig)
> >
> > There is an error if an MS Access table has a text field size of 254 but
> 200
> > works fine.
> >
> > Exact error: "The data value could not be converted for reasons other
than
> > sign mismatch or data overflow. For example, the data was corrupted in
> the
> > data store but the row was still receivable"
> >
> >
>
>