VSO2002: You Receive the "AD&L Functionality Is Not Available" Error Message When You Try to Use the AutoDiscovery and Layout Solution (810629)


The information in this article applies to:

  • Microsoft Visio 2002 Professional
  • Microsoft Visio Enterprise Network Tools
  • Microsoft Visio Network Central

SYMPTOMS

When you try to use the AutoDiscovery and Layout solution in Visio 2002, you may receive the following error message:
AD&L functionality is not available in this document because it is not connected to a database. Please re-open solution.

CAUSE

This issue may occur if the Microsoft Data Engine (MSDE) cannot locate the Adlclassmap.mdf file. This issue may also occur if you remove, and then reinstall MSDE.

When MSDE is removed from the computer, it does not remove the ADLclassmap database files such as Adlclassmap.mdf and Adl.mdf, that are created by the AutoDiscovery and Layout solution. As a result, these files remain in the drive:\Program Files\Microsoft SQL Server\MSSQL\Data folder on your hard disk, where drive is the drive on which MSDE is installed. When you reinstall MSDE, MSDE does not recognize and use the database files although they exist in the same location.

RESOLUTION

To resolve this issue, delete the ADLclassmap database files. After you delete the database files, you can use the AutoDiscovery and Layout solution to perform a network discovery to create a new database:
  1. Quit Visio 2002.
  2. Start Microsoft Windows Explorer, and then locate the following folder, where drive is the drive on which MSDE is installed:

    drive:\Program Files\Microsoft SQL Server\MSSQL\Data

  3. Right-click the Adlclassmap.mdf file, and then click Delete.
  4. When you are prompted to confirm the deletion, click Yes.
  5. Right-click Adl.mdf, and then click Delete.
  6. When you are prompted to confirm the deletion, click Yes.
  7. Start Visio 2002.
  8. On the File menu, point to New, point to Network, and then click AutoDiscovery and Layout.
  9. On the AutoDiscovery menu, point to Discovery, and then click Discovery Wizard.

    Follow the instructions that appear to perform a network discovery and create a database of devices that are found on your network.

MORE INFORMATION

For additional information about how to troubleshoot a similar issue, click the following article number to view the article in the Microsoft Knowledge Base:

300017 Visio2002: "AD&L Functionality Is Not Available" Error Message When You Attempt to Use AutoDiscovery and Layout Template

For more information about how to troubleshoot AutoDiscovery and MSDE in Visio, visit the following Microsoft Web site:

http://netc.members.microsoft.com/content/P5822.asp

Modification Type:MinorLast Reviewed:1/6/2006
Keywords:kbprb kberrmsg KB810629
©2004 Microsoft Corporation. All rights reserved.