Default Settings

---

This section lists the settings that are relevant to client networking.

TCP/IP is the default protocol for Pervasive.SQL. That is, TCP/IP is tried first if more than one protocol is set to be available.

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 in the Server configuration.

---

Note
This feature is not available on 16-bit clients.

---

Supported Protocols

Default: SPX, TCP/IP, 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 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 SPX support may reduce the wait time during initial connections to the engine.

On Linux platforms, TCP/IP is the only supported protocol on the server.

---

Note
Server engines do not support the NetBIOS protocol. Workgroup engines do not support the SPX protocol.

---

TCP/IP Timeout for Communications Requester

Default: 15 seconds
This setting specifies the number of seconds the requester should wait for a TCP/IP connect request to succeed before timing out.