Using SPX to Connect to a Windows NT/2000 Server

---

This section documents the use of SPX when connecting to a Pervasive.SQL server running on a Windows NT/2000 machine.

Name Resolution

If you are using Btrieve applications only, then you can use SPX in an all-Windows environment. If you have an ODBC application, however, Pervasive.SQL depends on NetWare for name resolution. You will need at least one NetWare server to perform name resolution for your ODBC applications.

Tasks

Configuring Pervasive.SQL V8 to use IPX/SPX

IPX/SPX is not a native protocol on the Windows NT/2000 platforms. If you want to use IPX/SPX, perform all of the following procedures to ensure proper operation with Pervasive.SQL.

Changing Pervasive's configuration to use IPX/SPX with Windows NT/2000:

   If you have both TCP/IP and IPX/SPX Installed in the Network Icon of the Control Panel, you must remove
TCP/IP from the client configuration to make IPX/SPX function with Pervasive applications:

1. Click Start, point to Programs and select Pervasive.SQL V8.
2. Select Control Center.
3. Expand Pervasive.SQL Engines and expand the desired engine.
4. Expand Configuration and expand Client.
5. Select the Communication protocols and, in the right-hand pane, right-click on Supported protocols.
6. Highlight Microsoft TCP/IP from the list of selected protocols and click the < button to move it off the selected list.
7. Click OK.

Changing Windows Configuration to Make IPX/SPX Run with Pervasive.SQL:

   Ensure that your IPX/SPX settings are correct

In the Windows NT Control Panel:

1. Click Start, point to Settings and select Control Panel.
2. Double-click on the Network icon.
3. Select IPX/SPX Compatible Transport and click Properties.
4. Click the Advanced tab.
5. Under Frame Type setting, ensure that the correct frame type for your network is selected. Do not use Auto Frame Type Detection.
6. Still under the Advanced tab, click Network Address.
7. Enter a non-zero value for your network address. For information about what your network address should be, contact your system administrator.

In the Windows 2000 Control Panel:

1. Click Start, point to Settings and select Control Panel.
2. Double-click on the Network and Dial-up Connections icon.
3. Select Local Area Connection and click Properties.
4. Scroll down to IPX/SPX/NetBIOS Compatible Transport, highlight and click the Properties button.
5. In the Frame Type field, ensure that the correct frame type for your network is selected. Do not use Auto Detect.
6. In the Network number field, enter a non-zero value for your network address. For information about what your network address should be, contact your system administrator.

   Ensure that your IPX/SPX Maximum Packet size (MaxPktSize) is set correctly in the Windows NT/2000 registry:

1. Click Start and select Run.
2. Type regedit and press Enter.
3. Find the registry entry using the following paths:
   Windows NT: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\NwlnkIPX\NetConfig\driver_name\MaxPktSize.
   Windows 2000: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\NwlnkIPX\Parameters\Adapters\name\MaxPktSize.
4. Ensure that the MaxPktSize setting in the Windows registry is set to 576 decimal or 240h.