PreviousGetting Started with Pervasive PSQL v9 SP2 (9.5) (Workgroup edition) (v9 SP2 (9.5) revision 1) Next

Default Engine Settings

Chapter contents

This section explains what server Configuration settings are related to networking support, and what the default values mean.

You can change these settings within PCC on the engine properties for Communication Protocols.

Auto Reconnect Timeout

Default: 180 seconds
If Pervasive AutoReconnect is enabled, this setting specifies how long the engine and client attempt to contact each other after a network interruption has occurred. By default, the client, server and multiple workgroup engines attempt to reconnect for three minutes before giving up. If the value of Enable Auto Reconnect is Off, then the Auto Reconnect Timeout value is ignored.

Enable Auto Reconnect

Default: Off
This setting determines whether the client, server or multiple workgroup engine attempts to reconnect to each other in the event of a network outage. If set to On, it allows the database connections to recover from intermittent or temporary network interruptions. If this value of this setting is Off, then the client returns a status code to the application immediately upon any failure to connect to the server, and the connection context is not preserved.

If you have this setting turned On, you can specify how long the client and database engine should attempt to reconnect by using the setting Auto Reconnect Timeout.

Listen IP Address

Default: 0.0.0.0
This setting specifies the IP address of the network interface card that the MicroKernel should listen on when the server computer has two network cards installed. This value is ignored if the server computer has only one network card, or if the value of TCP/IP Multihomed is On. This value is also ignored if TCP/IP is not in use by the database engine.

NetBIOS Port

Default: 66
This value specifies the port number the Workgroup engine listens on when using NetBIOS communications. The Server engine does not support NetBIOS, so this setting is ignored by the Server engine.


Note
This port setting must be the same for all Workgroup engines on the network. Workgroup engines with different port settings cannot communicate with one another.

Supported Protocols

Default: TCP/IP, SPX, NetBIOS
This setting specifies the vendor protocols that the database engine should attempt to use. When more than one protocol is specified, upon start up, the client attempts to connect on all specified protocols. The protocol that connects first is then used for the remainder of the session.

You can often improve initial connection performance by removing the protocols that are not used on your network. For example, if you have a Workgroup engine on an all-TCP/IP network, removing NetBIOS and SPX support may reduce the wait time during initial connections to the engine.

TCP/IP Multihomed

Default: On
If your server computer has two network interface cards installed, you can use this setting to specify whether the server engine should listen on both network connections. If your computer has two network cards and this setting is turned off, you must use the setting Listen IP Address to specify which network card the server engine should use.


Chapter contents
Book contents

Prev topic: Determining What Kind of Network You Have
Next topic: Setting Up TCP/IP Support