Paradox connection strings

Intersolv 3.11 ODBC Driver

7.X

DataDirect provides this Paradox 7.x table format driver with read-write capability. Note that Paradox tables remain frozen at table format 7.x, That means that software mentioning Paradox 8, 9, 10 tables are really always referencing format 7.x.

DSN=MyDSN;AUT=1;CT=7;DQ=0;FOC=0;IS=1;PW=myPassword;USF=1;ULQ=1;

Not all parameters are required, most of them can be set at the DSN system config.

Parameters definition
AUT - ApplicationUsingThreads
CT - CreateType
DB - Database
DSN - DataSourceName
DQ - DeferQueryEvaluation
FOC - FileOpenCache
IS - IntlSort
ND - NetDir
PW - Passwords
USF - UltraSafeCommit
ULQ - UseLongQualifiers

Microsoft Paradox Driver

5.X

Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.X;DefaultDir=c:\pathToDb\;Dbq=c:\pathToDb\;CollatingSequence=ASCII;

7.X

Provider=MSDASQL;Persist Security Info=False;Mode=Read;Extended Properties='DSN=Paradox;DBQ=C:\myDb;DefaultDir=C:\myDb;DriverId=538;FIL=Paradox 7.X;MaxBufferSize=2048;PageTimeout=600;';
Initial Catalog
=C:\myDb;

Please note that this one only supports read operations.