Microsoft KB Archive/88086

{|
 * width="100%"|

The information in this article applies to:
 * 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. See the error log file in the SQL Server boot directory. And in the error log, you might find this message: Invalid network type ('DBMSNP') in Profile String for application (Server) 'SQLSERVER_' and key (Service) 'Query'.

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

SQLSERVER_ QUERY:DBMSNP,

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_ section in the OS2.INI file, use the entry &quot;DBNMPP&quot;, as shown below:

SQLSERVER_ QUERY:DBNMPP, You do not need to have the DBNMPP.DLL file on your machine.

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.
 * }

-

Last reviewed: April 28, 1997

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.