Copyright: , 1995 INTERSOLV


	DataDirect ODBC  Paradox Driver
Paradox ODBC Setup

Entering Paradox Passwords

Copyright


Copyright
Copyright 1995 INTERSOLV Inc. All rights reserved. INTERSOLV is a registered trademark, and DataDirect is a trademark of INTERSOLV, Inc. Other company or product names mentioned herein may be trademarks or registered trademarks of their respective companies.


Paradox ODBC Setup
Configuring a Paradox Data Source

Data Source Name:  A string that identifies this Paradox data source configuration in ODBC.INI.  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 number 1."

Database Directory:  The directory in which the Paradox files are stored.  If a directory is not specified, the current working directory is used.

The following values are optional:

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

File Open Cache:  A numeric value to specify the maximum number of unused file opens to cache.  For example, the value 4 specifies that when a user opens and closes four 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 file open caching is increased performance.  The disadvantage is that a user who specifies file locking on open may get a locking conflict even though no one appears to have the file open.  The default is 0, which means no file open caching.

Create Type:  The table version for Create Table statements.  The default is 4 for Paradox 4.0 or 4.5 tables.  Specify 3 for Paradox 3.0 or 3.5 tables.

Lock While Reading Blobs:  This check box, when selected, indicates that records containing blob data types (BLOB, OLE, Graphic, Formatted Memo, and Memo) are to be locked before they are fetched.

International Sort:  A setting to indicate the order in which records are retrieved when you issue a Select statement with an Order By clause.  Select this check box to use the international sort order as defined by your operating system.  International sort order is case-insensitive (a precedes B); the sorting of accented characters is also affected (see your operating system documentation).  Leave this box blank to use ASCII sort order.  ASCII sort order is case-sensitive, where uppercase letters precede lowercase letters (B precedes a).

Leave this box blank to use the ASCII sort order, where uppercase letters precede lower case letters (B precedes a).

Read Consistency Isolation Level:  This check box, when selected, indicates that tables are locked to assure that all records can be reread within a statement.

Translate: Displays the Select Translator dialog box to allow you to perform a translation of your data from one character set to another. Choose the INTERSOLV OEM ANSI translator to translate your data from the IBM PC character set to the ANSI character set.


Entering Paradox 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 INTERSOLV DataDirect ODBC Drivers Reference or double-click the Driver help icon.