Microsoft KB Archive/321576

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

Article ID: 321576

Article Last Modified on 1/20/2006

-

APPLIES TO


 * Microsoft Visio for Enterprise Architects 2002, when used with:
 * Microsoft Visual Studio .NET 2002 Enterprise Architect

-



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:

&quot;Refetching view  definition&quot;

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 &quot;Applies to&quot; section. This problem was first corrected in Visio for Enterprise Architects 2002 Service Release 1 (SR-1).



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?

Additional query words: kbVSNETEntArch2002sr1Fix vso2002

Keywords: kberrmsg kbtshoot kbbug kbfix kbvs2002sp1sweep kbvs2005swept kbvs2005doesnotapply KB321576

-

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

© Microsoft Corporation. All rights reserved.