Using SPX to Connect to a NetWare Server

This section documents the use of SPX when connecting to a Pervasive PSQL server running on a NetWare machine.

Configuring Pervasive PSQL to use SPX

SPX is a native protocol to NetWare. There should be no special requirements for operating Pervasive PSQL with SPX on NetWare. However, note the following:

SPX is not the default protocol for Pervasive PSQL. Consequently, if you have both TCP/IP and SPX installed, Pervasive PSQL attempts to use TCP/IP first. If you want SPX to be used, follow these steps:

To Configure your Clients to use SPX with NetWare Servers if Both TCP/IP and SPX are Installed:

Click Control Center from the Pervasive program on the Start menu.

In the Pervasive PSQL Explorer, expand Local Client.

Right-click on MicroKernel Router and select Properties.

Click Communication protocols. In the window to the right, a list of Supported protocols displays.

Uncheck TCP/IP from the list of selected protocols.

Click OK.

Changing the Default Server Listening Port (Advanced)

Most users should never have to use this procedure. This procedure should only be performed by a system administrator.

In normal TCP/IP operation, clients use a particular port number to communicate with servers. Pervasive PSQL by default listens on port 1583. For TCP/IP to function properly, all clients and all servers must use the same port.

Pervasive recommends that you do not modify the server listening port unless you have a conflict with port number of 1583. If you do have a conflict, you can override the Pervasive Database port settings with an entry in the SERVICES file for each machine. The SERVICES file is located at:

SYS:\ETC\SERVICES

For example, if you wanted to change the listening port to 80 for Pervasive PSQL, you would add the following entry in your SERVICES file:

psql 80/tcp

After changing your server listening port, you must stop and restart your Pervasive PSQL services for the changes to take effect. See "Using Pervasive PSQL" in Pervasive PSQL User's Guide.

Note
Entries in the NetWare SERVICES file are NOT case-sensitive.