System INIT settings

<< Click to Display Table of Contents >>

Navigation:  Configuration topics > BDE configuration settings > System settings >

System INIT settings

Previous pageReturn to chapter overviewNext page

The System INIT settings are the settings the BDE uses to start an application. This information is stored in the Windows Registry.

To display these settings:

1.Click the Configuration tab in the left pane and expand Configuration in the settings tree.

2.Expand System in the tree.

3.Expand INIT in the tree.

4.The settings appear on the Definition tab in the right pane.

In the following table, Parameter lists all the configurable system and network parameters, with their current values. When your BDE application is first installed, all values are set to their defaults.

Description briefly notes the purpose of the selected parameter.

To change a setting, highlight the desired parameter. Then replace its old value with a new value. When edits are complete, choose Object|Apply or click the Apply button to save the changes.

Parameter

Description

AUTO ODBC

Set to TRUE to import installed ODBC drivers and datasources every time BDE is initialized. Default: FALSE. Note: Setting AUTO ODBC to TRUE is no longer recommended because of the Virtual configuration mode setting. For more information, see Options dialog box.

DATA REPOSITORY

The name of the active data dictionary.

DEFAULT DRIVER

Driver first tried when TYPE is FILE and the table name has no extension. Also, for files with a .DBF extension, specifies whether to use the dBASE or FoxPro driver.

LANGDRIVER

System language driver that defaults to the OEM driver appropriate for a country's version of Windows; for example, 'ascii' ANSI (DBWINUS0) for US workstations.

LOCAL SHARE

The ability to share access to local data between an active BDE application and an active non-BDE application. Set to TRUE if you need to work with the same files through both a BDE and a non-BDE application at the same time. (It is not necessary to set LOCAL SHARE to TRUE if you do not need to have both applications open at the same time.) Default: FALSE.

LOW MEMORY USAGE LIMIT

Maximum amount of low memory the BDE will attempt to use, in kilobytes. Default: 32.

MAXBUFSIZE

Maximum amount of memory for database data cache, in kilobytes. Can be any integer between MINBUFSIZE and 65,535 (inclusive). Must be a multiple of 128. Default: 2048.

MAXFILEHANDLES

Maximum number of file handles the BDE uses. Can be any integer ranging from 5 to 4096. High values improve performance but use more Windows resources. Default: 48.

MEMSIZE

Maximum amount of memory that BDE will use, in megabytes. Default: 16 MB. Maximum 205. Any number specified over 205 sets MEMSIZE to 205.

MINBUFSIZE

Minimum amount of memory for database data cache, in kilobytes. Can be any integer between 32 and 65535. Must be less than the total amount of RAM available to Windows. Default: 128.

MTS POOLING

Set to TRUE to enable MTS pooling, thus improving the initial connection time of opening a database. Default: FALSE.

SHAREDMEMLOCATION

Preferred address of shared memory manager. The shared memory manager and shared buffer manager load at a preferred address. If this address is used, the system can find a suitable address (first process only). If this address conflicts with another application, you might want to modify it. If the shared managers cannot be loaded into the default, or specified memory address, one attempt to allow the operating system to find a memory address is made. If a memory address if specified outside the boundry (below), the default is used.
 
Default (for Windows 95): 0xEBDE0000
Minimum Value (for Windows 95): 0x90000000
Maximum Value (for Windows 95): 0xFFFF0000
 
Default (for Windows NT): 0x6BDE0000
Minimum Value (for Windows NT): 0x10000000
Maximum Value (for Windows NT): 0x7F000000
 
The range setting for SHAREDMEMLOCATION is 9000 to FFFF for Windows 95 and 1000 to 7F00 for Windows NT. Only the upper word is used to set SHAREDMEMLOCATION

SHAREDMEMSIZE

Maximum amount of memory BDE will use for shared resources, in kilobytes. Default: 2048 KB. Minimum: 2048 KB.  If a value below 2048 is specified, 2048 will be used. File handles, drivers, and system, client and table objects are shared resources and SHAREDMEMSIZE should be increased when using many of these objects.

SQLQRYMODE

Method for handling queries to SQL data. Can be NULL, SERVER, or LOCAL. The SQLQRYMODE parameter appears only if a Borland SQL Link driver is installed. Default: NULL.

SYSFLAGS

Internal BDE setting. Do not modify.

VERSION

An internal setting that describes the current version of the BDE. Do not modify.