DOCUMENT:Q238676  25-FEB-2000  [vbwin]
TITLE   :PRB: Shared DLL Removal in SQL Makes VB Add-ins Unloadable
PRODUCT :Microsoft Visual Basic for Windows
PROD/VER:WINDOWS:6.0; winnt:7.0
OPER/SYS:
KEYWORDS:kbAddIn kbSQLServ kbVBp600 kbSQLServ700 kbGrpDSVBDB kbDSupport

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Visual Basic Professional Edition for Windows, version 6.0 
 - Microsoft SQL Server version 7.0 
-------------------------------------------------------------------------------

SYMPTOMS
========

When you load Visual Basic 6.0 after uninstalling SQL Server, the following
error occurs:

   #2050 cannot be loaded
   Remove it from the list of available add-ins?

Also, if you choose to load add-ins from Add-in Manager, you will see an error
message saying that the selected add-ins cannot be loaded.

CAUSE
=====

When you uninstall SQL Server or SQL Desktop, it may remove the shared DLL
msaddndr.dll.

RESOLUTION
==========

Do not remove msaddndr.dll when uninstalling. When Setup asks permission to
remove this file, choose not to remove it.

MORE INFORMATION
================

Steps to Reproduce Behavior
---------------------------

1. Install version 6.0 of Visual Basic Professional, Enterprise, or Enterprise
   or Professional (client applications only) edition on a workstation or server
   running Microsoft Windows NT 4 or Windows 2000.

2. Install Visual Studio Service Pack 3.

3. Install SQL Server Desktop Edition using the default install settings.

4. Uninstall SQL Server. Setup will prompt you whether to keep the shared file
   msaddndr.dll. Choose to remove the shared file.

5. Launch Visual Basic 6.0 and note that a warning message similar to the
   following appears:

   #2050 cannot be loaded
   Remove it from the list of available add-ins?

6. Select no and then create a new project.

7. From the File menu select Add-ins, and from the Add-ins menu select Add-in
   Manager.

8. Double-click any of the available add-ins to load them.

9. Select ok in the add-ins window. You will see a warning that the add-ins you
   selected cannot be loaded

Additional query words:

======================================================================
Keywords          : kbAddIn kbSQLServ kbVBp600 kbSQLServ700 kbGrpDSVBDB kbDSupport 
Technology        : kbVBSearch kbSQLServSearch kbAudDeveloper kbZNotKeyword6 kbSQLServ700 kbZNotKeyword2 kbVB600Search kbVB600
Version           : WINDOWS:6.0; winnt:7.0
Issue type        : kbprb

=============================================================================

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.

Copyright Microsoft Corporation 2000.