FIX: Process stops when you generate a text file of a DDL script and a new SQL Server database from Visio 2002 (321576)


The information in this article applies to:

  • Microsoft Visio for Enterprise Architects (2002), when used with:
    • Microsoft Visual Studio .NET (2002), Enterprise Architect Edition
This article was previously published under Q321576

SYMPTOMS

When you generate a text file of a data definition language (DDL) script and a new Microsoft SQL Server database, the process may stop and you may receive the following message in the Output pane:
"Refetching view DBCS characters definition"
When you receive this message, the user interface is disconnected from the database model.

CAUSE

This behavior can occur when view names in your database model diagram use double-byte character set (DBCS) characters.

RESOLUTION

To resolve this problem, obtain the latest service release for Visio for Enterprise Architects 2002. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

320765 Visio2002: How to obtain the latest Visio for Enterprise Architects 2002 service release

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Visio for Enterprise Architects 2002 Service Release 1 (SR-1).

MORE INFORMATION

Steps to Reproduce the Behavior

NOTE: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
  1. Click Start, click Control Panel, and then double-click Administrative Tools.
  2. Double-click Data Sources (ODBC), click the System DSN tab, and then click Add.
  3. Double-click SQL Server, type a name for this DSN, and then type a description for this DSN.
  4. Click the computer running SQL Server on which the database will reside, and then click Next.
  5. Click With Windows NT authentication using the Network Login ID, and then click Next two times.
  6. Click OK to accept the defaults, and then click Finish.
  7. Click Test Data Source. You receive a message that the tests completed successfully.
  8. Click OK, and then click OK again.
  9. Start Microsoft Visio for Enterprise Architects.
  10. On the File menu, point to New, point to Database, and then click Database Model Diagram.
  11. Drag an Entity shape from the Entity Relationship stencil to the diagram.
  12. Double-click the Entity shape to display the Database Properties task pane.
  13. In the Database Properties task pane, under Categories, click Columns, type Column1 for a Physical Name, and then click to select the PK (Primary Key) check box.
  14. Drag a View shape from the Entity Relationship stencil to the diagram.
  15. Double-click the View shape to display the Database Properties task pane.
  16. In the Physical Name text box, type a name that uses characters from the double-byte character set.
  17. In the Database Properties task pane, under Categories, click Columns, type Column1View for a Physical Name, and then click Edit.
  18. On the Source tab, click Known column in another table or view, and then click Change.
  19. Click to select Column1, and then click OK. Click OK again.
  20. On the Database menu, click Generate.
  21. Click to select the Generate a text file of the DDL Script and Generate a New Database check boxes.
  22. Click Next.
  23. On the Installed Visio Drivers list, click to select Microsoft SQL Server.
  24. Click Create Database.
  25. In the Data Source Name text box, type the DSN name that you typed in step 3. In the Database Name text box, type NewVisio, and then click Next.
  26. Type the appropriate information for User and Password, and then click OK.
  27. Click Next, click Finish, and then click Close.
  28. Click Yes for Do you want to view the generated DDL script?
Modification Type:MinorLast Reviewed:1/20/2006
Keywords:kberrmsg kbvs2005doesnotapply kbvs2005swept kbtshoot kbvs2002sp1sweep kbbug kbfix KB321576 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.