INF: Using SQL Transfer Manager Against a Sybase NLM

 Last reviewed: April 30, 1997
Article ID: Q120162

The information in this article applies to: 

  - Microsoft SQL Server, version 4.21

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

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 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.