Paradox Initialization Settings

The Jet\3.5\Engines\Paradox folder includes initialization settings for the Mspdox35.dll driver, used for access to external Paradox data. Typical settings for the entries in this folder are shown in the following example.

win32=<path>\MSPDOX35.dll
PageTimeout=600
CollatingSequence=ASCII
DataCodePage=OEM
ParadoxUserName=Kimberly
ParadoxNetPath=P:\PDOXDB
ParadoxNetStyle=4.Xx

The Microsoft Jet database engine uses the Paradox folder entries as follows.

Entry Description
win32 The location of Mspdox35.dll. The full path is determined at the time of installation. Values are of type String for Windows 95 and Windows NT 4.0, and of type REG_SZ for Windows NT 3.51.
PageTimeout The length of time between when data is placed in an internal cache and when it is invalidated. The value is specified in 100 millisecond units. The default is 600 units or 60 seconds. Values are of type DWORD for Windows 95 and Windows NT 4.0, and of type REG_DWORD for Windows NT 3.51.
CollatingSequence The collating sequence for all Paradox tables created or opened using the Microsoft Jet database engine. Possible values are:
  • ASCII

  • International

  • Norwegian-Danish

  • Swedish-Finnish

The CollatingSequence entry must match the collating sequence used when the Paradox table was built. The default is ASCII. Values are of type String for Windows 95 and Windows NT 4.0, and of type REG_SZ for Windows NT 3.51.

DataCodePage An indicator of how text pages are stored. Possible settings are:
  • OEM ? OemToAnsi and AnsiToOem conversions done.

  • ANSI ? OemToAnsi and AnsiToOem conversions not done.

The default is OEM. Values are of type String for Windows 95 and Windows NT 4.0, and of type REG_SZ for Windows NT 3.51.

ParadoxUserName The name to be displayed by Paradox if a table is locked by the Paradox ISAM and an interactive user accessing the data from Paradox (rather than the ISAM) attempts to place an incompatible lock. This entry is not added if the computer is not on a network. Values are of type String for Windows 95 and Windows NT 4.0, and of type REG_SZ for Windows NT 3.51.

Note If you indicate a ParadoxUserName, specify a ParadoxNetPath and a ParadoxNetStyle or you will receive an error when trying to access external Paradox data. Also, if you are accessing a Paradox database in multi-user mode over the network, you will have to add or modify this registry entry manually.

ParadoxNetPath The full path to the directory containing the Paradox.net file (for Paradox 3.x) or the Pdoxusrs.net file (for Paradox 4.x). This entry is not added if the computer is not on a network. Usually, you need to change the initial setting (added by the Setup program), which is a best guess at where the file might be. The full ParadoxNetPath (including the drive letter) must be consistent for all users sharing a particular database (directory). Values are of type String for Windows 95 and Windows NT 4.0, and of type REG_SZ for Windows NT 3.51.

Note If you indicate a ParadoxNetPath, specify a ParadoxUserName and a ParadoxNetStyle or you will receive an error when trying to access external Paradox data. Also, if you are accessing a Paradox database in multi-user mode over the network, you will have to add or modify this registry entry manually.

ParadoxNetStyle The network access style to use when accessing Paradox data. Possible values are:
  • 3.x

  • 4.x

Note Paradox 3.x users cannot set this to 4.x or the driver will use the wrong locking method. Paradox 5.0 users must use the 4.x ParadoxNetStyle setting to ensure proper locking behavior.

This entry is not added if the computer is not on a network. This entry should correspond to whatever version of Paradox the users in the group are using. It must be consistent for all users sharing a particular database (directory). The default is 4.x. Values are of type String for Windows 95 and Windows NT 4.0, and of type REG_SZ for Windows NT 3.51.

Note If you indicate a ParadoxNetStyle, you must also specify a ParadoxUserName and a ParadoxNetPath or you will receive an error when trying to access external Paradox data.