I am trying to read the data from a paradox database using OleDb connection string into a c# program:

ConnectionString= String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Da ta Source={0};Extended Properties=Paradox 4.x;Persist Security Info=True", DataBaseName);

* where DataBseName is the directory for paradox database

I am running into two problems:

(1) If data is stored as null for a boolean field, the result I am getting as true.
(2) If data is stored as binay type, the field is not even returned while making a query.

Any help is appreciated.

Thank you in advance.