Default Settings

---

When using Pervasive.SQL on a NetWare server, you can use either TCP/IP or IPX/SPX protocols.

When both network protocols are available, however, Pervasive.SQL clients will first attempt to use TCP/IP.

If you wish to use only IPX/SPX, you can disable TCP/IP using the Configuration utility as documented in Disabling Certain Protocols .

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 by double-clicking Configuration for the given database engine, then double-clicking Server, then Communication Protocols.

Auto Reconnect Timeout

Default: 180 seconds
If Pervasive Auto Reconnect 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 and server attempt to connect 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 and server attempt 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.

Supported Protocols

Default: SPX, TCP/IP
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 engine 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 Server 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.