Copyright: , 1995 INTERSOLV


	DataDirect ODBC  Paradox 5 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 "Paradox5-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.  You can also specify aliases that are defined in your IDAPI configuration file, if you have one.  To do this, enclose the alias name in colons.  For example, to use the alias MYDATA, specify ":MYDATA:"

The following values are optional:

Network Directory:  The directory containing the PARADOX.NET file that corresponds to the database you have specified.  If the Paradox database you are using is shared on a network, then every user who accesses it must set this value to point to the same PARADOX.NET file.  If not set here, this value is determined by the NetDir setting in the Paradox section of the IDAPI configuration file.  If you are not sure how to set this value, contact your network administrator.

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 Paradox table version desired for any Create Table statements that you execute.  You can specify 3, 4, 5, or leave the box blank and use the default, which is determined by the Level setting in the Paradox section of the IDAPI configuration file.  The numeric values map to the major revision numbers of the Paradox family of products.

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 supports two types of passwords:  master and auxiliary.  The Paradox 5 driver supports master passwords only and can manage up to 50 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 only encrypted tables for which a password appears in this list.  You can supply a password in three ways:  by typing it in the Password dialog box (which appears when the driver does not have the password to open an encrypted table), by including it in a connection string (with the Passwords attribute), or by using the Add Password statement.

Entering Passwords with a 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 attribute "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.