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

ID: Q80631

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.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

Although the correct Network Library (Net-Library) files seem to be used, the above message persists.

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.


Keywords          : kbtool SSrvSAF 
Version           : 4.2
Platform          : OS/2 
Issue type        :

Last Reviewed: March 12, 1999