Paradox Connection strings - Connectionstring Examples

Connection strings Examples for Paradox

Microsoft Jet OLEDB DB 4.0 Data Provider for Paradox

This is a OLE DB Provider from Microsoft. The usage for this is Provider=Microsoft.Jet.OLEDB.4.0.

Detail information can be view from Microsoft knowledge base.

Standard Security:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\yourDbFolder;Extended Properties=Paradox 5.x;

Note: Specify the Datasource as a folder instead of the database file name

Microsoft Paradox Driver

This is a ODBC Driver from Microsoft. The usage for this is Driver={Microsoft Paradox Driver (*.db )}.

Troubleshoot ODBC error.

5.X:

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

ODBC - Open Database Connectivity Overview.

7.X:

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

7.X only support read operation.

Intersolv 3.11 ODBC Driver

This is a ODBC driver from DataDirect Technologies. The usage for this is DSN=myDSN.

Troubleshoot ODBC error.

7.X:

DSN=yourDSN;AUT=1;CT=7;DQ=0;FOC=0;IS=1;PW=yourPassword;USF=1;ULQ=1;

    Note: Allow read-write operation for 7.X and now all parameters is required.

    Parameter Description:

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