Connecting to an ODBC Data Source

When you use the Export To Database or Link To ODBC Database command for the first time, you must set up and select an ODBC data source. Although you can use the Control Panel to set up an ODBC data source before exporting or linking, you don’t have to—Visio 2007 provides all the options you need. A data source is simply the particular database file you want to connect to. You need to tell Visio 2007 where to find the database program, as well as which ODBC drivers can communicate with it and which database file (or object) to use. Through this process, you create a file called a data source name (DSN), which saves the settings used to create the connection.

You can create different types of DSNs depending on ...

Get Microsoft® Office Visio® 2007 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.