simplyarun

Hi Friends,

I am trying to access and read a Paradox table using OleDbConnection

Here is the snippet of code that I am using:

=========================================

OleDbConnection ParConn;

DataTable schemaTable;

ParConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + folderName + ";Extended Properties=Paradox 5.x; Persist Security Info=False");

OleDbCommand myCmd = new OleDbCommand();

OleDbDataReader myReader;

myCmd.CommandType = CommandType.Text;

myCmd.Connection = ParConn;

myCmd.CommandText = "SELECT * FROM " + fileName;

ParConn.Open();

myReader = myCmd.ExecuteReader(CommandBehavior.SequentialAccess);

schemaTable = myReader.GetSchemaTable();

ParConn.Close();

=========================================

This code is getting all the feild info except for the BLOB data type. I need to read the BLOB data type also.

Any help would be highly appreciated.

Thanks in advance.

Arun Gupta




Re: .NET Framework Data Access and Storage Problem accessing paradox BLOB type in C#

Paul P Clement IV


I don't believe the Paradox ISAM driver supports BLOB data types. You may want to look at BDE (Borland Database Engine) or a third party solution (http://www.scalabium.com/pdx/pdxa.htm).






Re: .NET Framework Data Access and Storage Problem accessing paradox BLOB type in C#

simplyarun

Hi,

Thank you for your response.

I think having a tool will not solve my problem. Actually, I need to have a set of some APIs so that I can read the data in the BLOB field. I have to develope a tool in C# that would convert the paradox database to SQL server files.

Regards

-Arun