CONNECTING TO SQLBASE SERVER ON NOVELL NETWARE FROM WINDOWS FOR WORKGROUPS CLIENT

SQLBASE STRATEGIES

by Hari Chowlur, February 1995

Summary

This document provides details on connecting a WFW client on a Novell NetWare network to a SQLBase server running on Novell NetWare.

Environment


	Server:	 Novell NetWare

	Client:  Windows for WorkGroups

	Network: Novell NetWare Network

		 Windows for WorkGroups Network

Configuring Windows for WorkGroups Clients

  1. In the Networks Setup window, click on Networks.
  2. In Networks window, choose Install Microsoft Windows Network.
  3. From the menu along side the Other, choose Novell NetWare. If you are using VLM’s then choose, Workstation Shell 4.0 and above else choose Workstation Shell 3.26.
  4. Click on OK to return to the Network Setup window.
  5. Choose Drivers... to open the Network Drivers window.
  6. Click on Add Adapter.
  7. In the Add Network Adapter window, if WFWG is able to detect the adapter being used choose that or else choose to install IPXODI Support Driver (Ethernet). Choosing this option installs Microsoft NetBEUI and IPX\SPX Compatible Transport with NetBIOS.
  8. Click OK to exit Add Network Drivers window. This installs IPX/SPX Compatible Transport with NetBIOS as the default protocol. We recommend that you use IPX/SPX Compatible Transport instead of the driver installed by default. To do this highlight, IPX/SPX Compatible Transport with NetBIOS and remove it, by clicking on the remove button. Next click on Add Protocol and select IPX/SPX Compatible Transport and install this.
  9. Double click on IPX/SPX Compatible Transport. Choose the Frame Type used in the network, usually that would be Frame Ethernet_802.3 or Frame Ethernet_802.2.
  10. Click OK. in Network Setup window to begin the installation with the options you have selected. The system starts installing the components you have chosen.
  11. If Novell NetWare DOS Requester is already installed, a message appears notifying you that the required files are already in installed in the system and asking if you want to upgrade it with a newer version.
  12. If you have a newer version (for example you have just downloaded, WINUP9.EXE) you upgrade by selecting Yes or Yes to All. Otherwise, choose No and insert WFW installation disks 7 and 8 to complete the installation.
    The installation program modifies the AUTOEXEC.BAT, CONFIG.SYS, SYSTEM.INI, WIN.INI,andNET.CFG files. The program adds ODIHLP.EXE after the IPXODI.COM entry in the AUTOEXEC.BAT.

    Note: If you are using any other batch file (for example, NET.BAT) to load NetWare related modules, you must manually add ODIHLP.EXE after the IPXODI.COMstatement to that file and delete the entry from AUTOEXEC.BAT.

  13. It the prompt that invites you to reboot, click on No, and exit Windows.
  14. Edit CONFIG.SYS and set LastDrive=Z, if using VLM’s else if using NETX set LastDrive=P.
  15. Reboot the client and all the changes you have made take effect.

    This completes the configuration procedure for WFWG in Novell NetWare environment.

    SQLBase Client configuration

    1. Edit SQL.INI and uncomment the comdll entrie in the [winclient.dll] section to access SQLBase under NetWare: 
      	

	comdll=sqlspxw
    2. Using either SQLTalk or any other Gupta Client tools you should be able to make a connection to the SQLBase server on Novell NetWare.