INFO: Readmedt.htm: Microsoft Visual Database Tools Readme

 Last reviewed: December 11, 1997
Article ID: Q166885
The information in this article applies to:
  • Microsoft Visual Database Tools, version 1.0
  • Microsoft Visual InterDev, version 1.0

SUMMARY

Microsoft Visual Database Tools Readme

(c) Copyright Microsoft Corporation, 1997. All rights reserved.

This document provides late-breaking or other information that supplements the Microsoft® Visual Database Tools documentation.

MORE INFORMATION

Contents

  • Database Designer
  • Query Designer
  • Installation Issues
  • Handling Communication and TDS Protocol errors in Microsoft SQL Server

Database Designer

Printing a Database Diagram:

You can print a database diagram on any printer that supports raster graphics. Diagrams print at the current zoom level. If you want to enlarge or reduce your diagram, select a different zoom setting.

To print a database diagram:

  1. From the File menu, click Print.

  2. In the Print dialog box, select a printer from the Name list. You can also set any of the other available print options. For information about each option, click the What's This button in the top-right corner of the dialog box, and then click the field that you want to see information about.

  3. Click OK.

The tables and relationships that appear in your diagram will print exactly as shown on the screen with one exception: all of the tables in your diagram appear in their selected state in your printout for better contrast.

Query Designer

You can update data in the Results Pane of the Query Designer if:

  • The primary key column(s) have been included in your query for output.

CAUTION: If a table in your query uses a compound key (more than one column is used to make up the unique key for each row), you must include all parts of the key in the query. If the result set does not include all columns required for the compound key, any updates that you make in the Results pane might change more than one row in the table without warning.
  • The ODBC driver for the data source you're querying against supports SQLPrimaryKeys(). Such drivers include Microsoft SQL Server™, Microsoft Access, Microsoft Visual FoxPro™ v. 3.0 and later, and Oracle.

Installation Issues

You must install the Microsoft(R) SQL Server(TM) 6.5 Service Pack 1 or later to run the Database Designer. For best performance, we recommend Service Pack 2.

Handling Communication and TDS Protocol Errors in Microsoft SQL Server

You can get a TDS Protocol error or a Communications Link Failure when you're working against Microsoft(R) SQL Server(TM) under certain conditions, including running SQL Trace against the server.

If such a problem occurs, right-click the data connection in Data View and select Refresh from the shortcut menu. If you find that the problem is caused by SQL Trace, close SQL Trace and then refresh the connection.

REFERENCES

Readmedt.htm

REFERENCES

For the latest Knowledge Base articles and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site: 

   http://support.microsoft.com/support/vinterdev/


Keywords          : VIMisc
Version           : 1.0
Platform          : WINDOWS
Issue type        : kbreadme

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

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.

Last reviewed: December 11, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.