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 |