INF: RPCs from NT SQL Server to Sybase UNIX SQL Server

 Last reviewed: April 28, 1997
Article ID: Q104600

The information in this article applies to: 

  - Microsoft SQL Server version 4.2

SUMMARY

Microsoft SQL Server version 4.2 for Windows NT can be configured to send RPC requests to a remote Sybase UNIX SQL Server. SQL Server for Windows NT uses DB-Library to communicate with remote servers, thus, you can configure remote server connections to use alternate network libraries and connection strings by using the SQL Client Configuration Utility.

To setup a connection to a Sybase Server running under UNIX, you would add an Advanced entry such as: 

   Server: SybaseServer

   DLL Name: dbmssocn

   Connection String: 11.1.4.67,3180

MORE INFORMATION

It is advisable to attempt to connect to the remote server using an ad- hoc query tool such as ISQL after adding the Advanced entry using the SQL Client Configuration Utility. After confirming that the configuration is correct, you can add the remote server named SybaseServer via the sp_addserver stored procedure. When a remote stored procedure is executed on the Sybase Server, the configuration information in the Advanced entry will be used in order to establish a connection.

NOTE: The DBMSSOCN.DLL should be used ONLY to allow SQL Server to connect to a remote Sybase Server. This file cannot be distributed to other NT client workstations.

Additional query words:
Keywords : kb3rdparty SSrvWinNT
Version : 4.2
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.