PDA

View Full Version : Paradox *db or *.mdb?


Mikate
07-02-03, 18:28
Hi all

According to someone the way to connect to a paradox database is to use the following string.


'Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\My Database.mdb;Extended Properties="Paradox 7.X;"';

My question is as follows.....

In the example the database is a *.mdb NOT *.db..How is this? Have they changed paradox or what?

I have made a paradox 7 database that I want to start using with ADo instead of the old BDE. BUt I cant connect to it...and I dont know why.

Does anyone have a hint how I should proceed?

Thanx

Shores
08-27-03, 17:11
You should create an ODBC data source in the control panel, using Ms Paradox File Driver, and point id to the DIR that contains your .DB files, and then connect directly to the datasource you've created.

Be aware though that Ms Pdox Odbc drivers are known to have many glitches.