Setting Up SPX Support

SPX is supported between Pervasive.SQL clients and servers. If you have modified the default settings or need to verify that SPX support is available, refer to this section.

Your network's SPX Frame Type setting does not have any effect on Pervasive.SQL.

Note
In order to perform any of the tasks in this section, you must have administrative rights on the NetWare server, or be a member of the Pervasive_Admin group defined on the server.

Enabling SPX Support

Complete the following steps to ensure that the database server engine can communicate with clients over SPX networks.

Remember that you also need to confirm that your client computers are configured to use SPX, as well. See Chapter 18, Configuring Network Communications for Clients.

Note
In an all-Microsoft environment, SPX can be used with applications that use only the Pervasive.SQL transactional interface. With ODBC applications that use the relational interface, a NetWare server must be present to provide name resolution for SPX. Applications that use only the transactional interface do not require name resolution with SPX.

Start Pervasive.SQL Control Center (PCC) from the Pervasive program on the Start menu.

In the PCC Pervasive.SQL Explorer, double-click Engines to display a list of the engines registered with PCC.

Right-click on the icon representing your target engine then click Properties. Login if prompted.

Click on Communication Protocols.

In the window to the right, a list of Supported protocols displays. If the list of supported protocols shows the option SPX as checked, then SPX is already supported. Skip the remaining steps in this task.

If the list of selected protocols does not show the option SPX as checked, complete the remaining steps.

Click the option for SPX

Click OK.

Click Yes to restart the database engine.