Connecting to an ODBC Data Source
When you use the Export To Database or Link To 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 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 where to find the database program, 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 whether you want to share ...
Get Microsoft® Office Visio® 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
