I am developing a windows form application in C#. I have one Microsoft Access 2007 .accdb file. This DB file contains 2 Tables. In each table there are 145 columns. I am making oledb connection to this file etc., Its OK. Data from TABLE1 I search, based on some other process results. If match is found I read this row from TABLE1 and the column which has no null data (Check for doing this
if (TABLE1.READER.IsDBNull(counter) == false)
for this ROW. If this condition is satisfied, at same moment I make connection with TABLE2. And it has only one ROW so I directly pick the data from the same column number (counter). This all I do in a while loop, then concat (add) them as a single string and I write it to a plain ASCII file for further processing. It is able to read the first row of both the table and write them successfully to a ASCII file without any error, in while loop it starts reading the second row and is able to read the data upto 131 (counter) column and for 134 (counter) it is unable to make connection with the TABLE2 and give “Unspecified ERROR” in exception Catch. Any solution to this problem.