Microsoft KB Archive/275564

= FIX: Error Adding a DB2 OLEDB Linked Server as a Subscriber Using Babylon Provider =

PSS ID Number: 275564

Article Last Modified on 8/27/2002

-

The information in this article applies to:


 * Microsoft SQL Server 7.0

-



This article was previously published under Q275564



BUG #: 58381 (SQLBUG_70)



SYMPTOMS
If you add a DB2 OLEDB as a linked server using the latest version of the Babylon provider, which comes with SNA Server 4.0 Service Pack 3, and then try to add this linked server as a subscriber using the Enterprise Manager user interface, you may receive the following error message:

Error 21076:[SQL-DMO] The DSN infromation provided is either incorrect or incomplete.



WORKAROUND
Use sp_addsubscriber, instead of the Enterprise Manager user interface, to add the subscriber.

For more information on sp_addsubscriber, see SQL Server Books Online.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0. For information about how to download and install the latest SQL Server Service Pack, see the following Microsoft Web site:

http://support.microsoft.com/highlights/sql.asp

For more information, contact your primary support provider.

Additional query words: dsn babylon subscriber 21076

Keywords: kbbug KB275564

Technology: kbAudDeveloper kbSQLServ700 kbSQLServSearch

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2004 Microsoft Corporation. All rights reserved.