Copyright: Copyright © 1982-2001 Pervasive Software Inc. All Rights Reserved


Create Database

Database Name: The name that identifies the database.

Integrity Enforced Select this check box to enforce integrity constraints, including security, referential integrity, and triggers.

Bound (DDFs created) Select this check box to bind the database.

Dictionary Location Enter the path and directory location where the data files are located. You may select a different location using the Browse... button.

Data File Locations The path and directory location(s) for the data files. You may add or remove locations using the Add... and Remove buttons.

Tip

 If you are creating a database that resides on a machine with the Server Engine, the dictionary location has to be local to the machine on which you are creating the database.

 If you are creating a database that resides on a a machine with the Workgroup or Workstation Engine, the dictionary location can be local to the machine on which you are creating the database, or the dictionary files directory on a remote server.

NetWare Users: If the database resides on a NetWare server, the dictionary location should look something like sys:\pvsw\demodata.

Windows NT Users: If the database resides on a Windows NT server, the dictionary location should look something like d:\pvsw\demodata.


Create Engine DSN

Data Source Name: A name that identifies the data source.

For example: Personnel

DSN Description: An optional description of the data in the data source.

For example: Hire dates and salaries of employees.

Database Name: The name that identifies the database.

The Create... button allows you to create or add new Database Names on the remote server.

Database Configuration Details

Dictionary Location: The path and directory for the data files.

Data File Locations: The path and directory locations for all the data files.

Integrity Enforced: Displays if integrity constraints are enforced.

Bound: Displays if the database is bound.

You can select the Options... button to set the open mode.


Modify Engine DSN

Data Source Name: A name that identifies the data source.

For example: Personnel

DSN Description: An optional description of the data in the data source.

For example: Hire dates and salaries of employees.

Database Name: The name that identifies the database.

The Create... button allows you to create or add new Database Names on the remote server.

Database Configuration Details

Dictionary Location: The path and directory for the data files.

Data File Locations: The path and directory locations for the data files.

Integrity Enforced: Displays if integrity constraints are enforced.

Bound: Displays if the database is bound.


Options (Client)

Network

Enable Array Fetch Click this check box to enable array fetching. The default setting is to enable array fetching.

Array Fetch Buffer Size: Enter a new value between 1 and 64KB. The default setting is 8KB.

Tip

 Leave array fetching on unless you're just retrieving single rows of data with your driver.

TCP/IP Port Number

Default: Select the Default checkbox to use the default TCP/IP Port Number (1583). Click to clear the Default checkbox and enter a new TCP/IP port number in the box.


Options (Engine)

The open mode may be specified in the SQLSetConnect call options. It is in effect for the duration of a session. The open mode may affect whether a given action is valid or not.

Normal - permits shared read/write access. Integrity checks are performed when files are updated.

Read Only - permits only read operations on the file. Operations such as INSERT, UPDATE, and DELETE will fail. DDL statements are not permitted in this mode.

Accelerated - is the same as Normal mode except that certain transaction features are not in effect (e.g., file is not flagged as transactional). It provides improved response time when updating files but increases the chance that a crash could damage data integrity.

Exclusive - permits non-shared read/write access. No other task is permitted to open a file opened in this mode until that file is closed by the current task.


Pervasive ODBC Client DSN

Client

Data Source Name: A name that identifies the data source.

For example: MyData

Description: An optional description of the data in the data source.

For example: Pervasive ODBC Client Interface

The Options... button allows enabling and configuration of advanced options.

Server

Address: The address of the server or host name where the data resides. This can be a machine name, TCP/IP address or an IPX/SPX address.

For example: 172.16.5.247

Transport Hints: Displays a list of available transports to check for the Server Name, in the order in which they should be searched.

For example: TCP, SPX

Data Source Name: A system DSN on the server.

Use the Create... button to create or add a new Data Source Name on the server.

Use the Modify... button to change an existing Data Source Name on the server.

Tip

Engine DSNs created remotely are system DSNs.

You can click the Test button when you complete the Pervasive ODBC Engine DSN dialog box to verify a successful connection.