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