BUG: SQL Bridge on Alt Pipe and Remote Stored Procedure

• Microsoft SQL Server version 4.2 for OS/2

SYMPTOMS

When running SQL Server on the default pipe (\pipe\sql\query) and running SQL Bridge on an alternate pipe, an attempt to do remote stored procedures from Microsoft SQL Server to Sybase SQL Server might generate the following message:

   Can't open connection to site <servername>. See the error log
   file in the SQL Server boot directory.

   Invalid network type ('DBMSNP') in Profile String for
   application (Server) 'SQLSERVER_<Servername>' and key
   (Service) 'Query'.

CAUSE

This problem occurs because SQL Server checks for an entry for "DBNMPP" instead of "DBMSNP" in the OS2.INI file in the following section:

   SQLSERVER_<Servername>
   QUERY:DBMSNP,<alt. pipe name>

WORKAROUND

To execute remote stored procedures from Microsoft SQL Server to Sybase SQL Server with SQL Bridge running on an alternate pipe, under the SQLSERVER_<servername> section in the OS2.INI file, use the entry "DBNMPP", as shown below:

   SQLSERVER_<Servername>
   QUERY:DBNMPP,<alt. pipe name>

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.