Database Settings

In the Database Settings dialog box, you can set certain aspects of Open Database Connectivity (ODBC) behavior. After you have linked Microsoft Office Visio shapes or drawings to databases created in ODBC-compliant applications, the settings control how the changes are passed between the database and the drawing.

The settings are global; that is, they apply to all the drawing-database links you establish in Visio.

ODBC settings

Number of update retries

Type the number of times you want to try updating a database or drawing if the first attempt fails.

Update retry interval (msecs)

Type the number of milliseconds between update attempts.

Time-out interval (secs)

Type the number of seconds after which the update attempts time out.

Default ODBC data source

Click the ODBC data source to which you want the Database Wizard or Link to Database command to link by default. When you are linking a shape to a database, you can specify a different data source.

Database monitor settings

Automatically refresh drawing page

Select this check box to refresh a monitored drawing to match a database at the interval you set in Refresh drawing interval.

Refresh drawing interval (secs.)

Type the number of seconds that you want to elapse before changes to a database are passed to a monitored drawing. If it takes longer than the time you enter to refresh a drawing, Visio adjusts the time accordingly.

Restore defaults

Click to reset all settings to their defaults, which are:

• Number of update retries, 3

• Update retry interval, 250 (msecs)

• Time-out interval, 30 (secs)

• Default ODBC data source, Visio database samples

• Automatically refresh drawing page, cleared.

• Refresh drawing interval, blank.