Contents for Paradox ODBC Driver

Paradox ODBC Setup

Entering Paradox Passwords


Paradox ODBC Setup
Additional Information for Configuring a Paradox Data Source

Data Source Name:

Identifies a single connection to a Paradox database. This can be any string. Examples include "Accounting" or "Paradox-Serv1."

Description:

An optional long description of a data source name. For example, "My Accounting Database" or "Paradox files on Server #1."

Database Directory:

The directory in which the Paradox files are stored. If none is specified, the current working directory is used.

File Open Cache:

Determines the maximum number of unused table opens to cache. For example, when FOC=4 and a user opens and closes 4 tables, the tables are not actually closed. The driver keeps them open so that if another query uses one of these tables, the driver does not have to perform another open, which is expensive. The advantage of FOC is increased performance. The disadvantage is that a user who tries to open the table exclusively may get a locking conflict even though no one appears to have the table open.

Table Version:

Determines whether Paradox version 3.0 or 4.0 tables should be created. Paradox 4.0 tables offer a variety of Blob types and composite indexes. Choosing Paradox 3.0 tables will keep tables compatible with Paradox 3.0 and 3.5

Sort Order:

The order in which records are sorted in a Paradox index. ASCII is the default. This option is for compatibility with international versions of Paradox.The options are ASCII (default), INTL, NORDAN, NORDAN4, and SWEDFIN. NORDAN4 is valid only for Paradox 4.0 and 4.5 tables.

Lock While Reading Blobs:

Turning this option on ensures that any Blob types associated with a record can be accessed. Leaving this option off may improve performance with tables that contain Blob types. When the option is turned off in shared environments, the user may get an error returned from the Paradox engine related to a Blob type being accessed after another user has already modified it. This option is relevant only for tables with primary keys and when the Read Consistency option is turned off.

Read Consistency Isolation Level:

Provides a higher level of read consistency for the table by using table locks rather than record locks. Assures any records within a statement can be reread without having another user delete them.

International Sort:

Determines the order that records are retrieved when you issue a Select statement. Check this box to use international sort order as defined by Windows. The sort is case-insensitive (a precedes B); the sorting of accented characters is also affected (check your Windows documentation for more information). Leave this box blank to use ASCII sort order, where uppercase letters precede lowercase letters (B precedes a).


Entering Paradox Passwords

Passwords:

Paradox tables may be encrypted to provide limited access to users who do not know the password. The driver maintains a list of passwords for each connection. The driver can access encrypted tables only if the password exists in this list. Passwords are case sensitive and can be up to 15 characters long. Passwords can be added to this list by three different methods. The methods are outlined below.

Entering Passwords with Dialog Box:

The password dialog box appears when the driver does not have the password to open a encrypted table. Entering the password into the dialog box will enable the driver to access that table for the rest of that connection.

Entering Passwords During the Connection:

You may enter passwords that may be needed during a connection as a connection option. Use connection option "Passwords" to enter a comma-separated list of password names.

Entering Passwords with the Add Password Statement:

You may enter passwords by executing the ADD PASSWORD statement. For further help with ADD PASSWORD, consult the Q+E Database Driver Reference or double-click the Driver help icon.