ODBC Data Source |
When you select ODBC Data Source as the Database Platform in the Add Database Connection Wizard, you need to select or create an ODBC data source from which to read data. For more detailed instructions on how to select an ODBC data source, see Selecting a Named ODBC Data Source.
Once an ODBC data source has been properly selected or created, individual databases can be accessed by specifying the data source name rather than a database file or location.
Type. Specifies the type of ODBC data source.
User Data Source. A local database that is accessible only to the currently logged in user.
System Data Source. A local database that is accessible to anyone on the network who has sufficient access privileges.
File Data Source. A database anywhere on the network.
Data Sources. Lists all of the data sources currently set up a in the ODBC Administrator. Available if User Data Source or System Data Source is selected as Type.
Enter the DSN file name. Specifies the path and file name of the data source. Available if File Data Source is selected as Type.
Select File. Allows you to navigate to the desired data source. Available if File Data Source is selected as Type.
ODBC Administrator. Opens the ODBC Administrator where you can create a new data source or modify an existing one.
Table Types. Opens the Table Types dialog where you can specify which kind of table types will be available.
Related Topics