INF: Using SQL Transfer Manager Against a Sybase NLM

ID: Q120162

The information in this article applies to:
  • Microsoft SQL Server version 4.2x

SUMMARY

This article discusses how the SQL Server Transfer Manager utility can be used to connect to a Sybase NetWare Loadable Module (NLM) SQL Server running on a Novell server in order to transfer a database from a Sybase NLM to a database residing on a Microsoft SQL Server for Windows NT.


MORE INFORMATION

In order to use the SQL Server Transfer Manager utility to transfer a database from a Sybase NLM SQL Server, you will need to configure the Novell server and Sybase NLM to support TCP/IP clients. You should consult your Novell and Sybase documentation for detailed information about installing and configuring the Novell server for TCP/IP support.

NOTE: An SPX/IPX connection can not be established using the Microsoft SQL Server SPX/IPX Network Library (Net-Library) (SSMSSPXN). These Net- Libraries were designed to connect to Microsoft SQL Server, which is an Application Server on a Novell network, not an NLM.

After you have successfully configured the Sybase NLM to accept connections from TCP/IP clients, the next step is to use the SQL Server Client Configuration utility to configure the Windows NT machine so that it can connect to the Sybase NLM. What you need to do is create a server alias:

  1. Go into the ADVANCE options.


  2. Provide a server name, this is the alias that you will use to connect to the Sybase NLM.


  3. Provide the TCP/IP Socket DLL (dbmssocn).


  4. Provide the connection string (<ip_address>,<socket_number>).


After saving the entry, you can then use this server alias to reference the Sybase NLM as the 'source server' when connecting with the SQL Transfer Manager utility.

Additional query words: SQL netware nlm Xfr Mgr Windows NT

Keywords : kb3rdparty kbtool SSrvTran
Version : 4.21
Platform : WINDOWS
Issue type :


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