• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 24. Connecting Diagrams and Data... > Connecting to an ODBC Data Source

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 the connection with other users. The following procedure creates a file-based DSN, which means the DSN is portable—you can copy it to any other computer, such as a laptop or another user’s computer. For added security, you can also specify a user or system DSN, both of which limit access to the DSN file to the user of your computer.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint