Encrypted Paradox 4,5?

[HombreDelEspacio]

I'm supporting a user with an application that uses an encrypted (password protected) Paradox db. Using MS Access 2000 I can open the database file(s) directly, am prompted for a password, and viola! I can see all of the data in the tables. Simple.

Except, I want to write an application in VB.NET (or VB) to get at this data and spit it out to a tab delimited file (after some massaging of the data). How do I do this? I have experience with ADO.NET connecting to a SQL Server. I've written ASP that connects to Access databases.

I set up a System DSN using the Paradox 4.X driver (provided by MS). This is the connection string I tried using in VisualStudio.NET

Provider=MSDASQL;Password=Foo;Persist Security Info=True;Data Source=Paradox Files;Extended Properties="DSN=Paradox Files;DefaultDir=C:\MYPROGS\THE_DATA;DriverId=282;FIL=Paradox 4.X;MaxBufferSize=2048;PageTimeout=5;PWD=Foo;"

When I use that, I get the error:
Could not decrypt data.

Any ideas?

Thanks,

Tim

I do not have BDE, Paradox, Delphi, or C++ Builder

 

[HombreDelEspacio]

For VB.NET:

OleDbConnection conOleDB = new OleDbConnection()

conOleDB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\myProgs\\Data;Jet OLEDBatabase Password=FOO;Extended Properties=Paradox 5.x;"

DataSet datSet = new DataSet()

conOleDB.Open()
OleDbDataAdapter adaptOleDB = new OleDbDataAdapter("SELECT * FROM BAR", conOleDB)

adaptOleDB.Fill(datSet, "BAR&quot