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

[Dan V.]

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 V.]

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.]

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

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.

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"