PRB: Unable to Access SQL Server from an OS/2 Client

  - Microsoft SQL Server version 4.2 for OS/2

SYMPTOMS

In trying to access SQL Server from an OS/2 client using ISQL, the following message appears:

   DB-Library network communications layer not loaded

CAUSE

The workstation may have been used to access a non-OS/2 SQL Server. If this is the case, there will be an entry in the OS2.INI file in the section for SQL Server indicating the name of the net-library layer to be loaded. This prevents the net-library layer (DBNMPP.DLL, in the case of OS/2) from being loaded and results in the above message.

WORKAROUND

The following are three workarounds to prevent this problem from occurring:

• Remove this entry from the OS2.INI file with an appropriate editor and reboot the machine.
• Reinstall OS/2 (thus, creating a new OS2.INI). NOTE: During reinstallation, do not answer "Yes" to the question about maintaining group information because this will preserve the existing OS2.INI file.
• In some cases (with similarly configured clients), it may be possible to copy over OS2.INI from a functioning OS/2 client. This requires rebooting both machines from MS-DOS or OS/2 bootable floppy disks. As a precaution, rename the old OS2.INI file in case it is needed again. This file is usually located in the \OS2 directory.