Driver Limitations

  • Thread starter Thread starter RS
  • Start date Start date
R

RS

Are there any limitations for Microsoft OLEDB text driver. I use Schema .ini
file to specify the columns. I have 280 columns in my schema file. Due to
the nature of the business that I am in I have to have dataset with that
number of columns. I get an error that says "Record is too large" If i only
leave 255 columns it works just fine. Is 255 a column limit?
 
¤ Are there any limitations for Microsoft OLEDB text driver. I use Schema .ini
¤ file to specify the columns. I have 280 columns in my schema file. Due to
¤ the nature of the business that I am in I have to have dataset with that
¤ number of columns. I get an error that says "Record is too large" If i only
¤ leave 255 columns it works just fine. Is 255 a column limit?
¤

This is a limitation of the Jet database engine which is used in conjunction with the Text ISAM
driver.

You may need to combine some of the fields and then split them apart once in a DataTable,
DataReader, etc.

The only other option I can think of is two split the Text file into two files, create two separate
queries to pull the data into two DataTables, and then create a DataRelation between the two
DataTables.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top