Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/104600

From BetaArchive Wiki

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

Q104600



The information in this article applies to:


  • Microsoft SQL Server version 4.2x





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.

Keywords : kb3rdparty
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2


Last Reviewed: March 18, 1999
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.