Selecting an ODBC Data Source Project Management Help

To import data from an ODBC database, first open the Open dialog box (File> Open), Click the ODBC button in the dialog box to open the Select Data Source dialog box, This dialog box is used to connect to file data sources that have ODBC drivers on your machine, File data sources can be shared with other users who have access to the same drivers -.Machine data sources are stored on your PC and cannot be shared, Machine data sources are recommended for use with Project 2000, but you can set up a file data source if you prefer.

Figure 19.9

                          Figure 19.9

If you want to use Project 2000 to analyze information about a database that is not listed in the File Data Sources list or Machine Data Sources list, first check with the database manufacturer to find out how to get a 32-bit ODBC driver, Often, you’ll find that it was included with the software. Also, check the Microsoft Web site (http://www.projectmanagementhelp.net) for additional ODBC drivers, To set up a file data source, set these options in the Select Data Source dialog box:

Look In drop-down list ‘Displays the current directory for which the sub, directories and file data source names (DSNs) are displayed.

File Data Sources list Displays all file DSNs and subdirectories contained within the directory displayed in the Look In drop-down list. Double-clicking a DSN connects to the data source.

DSN Name Displays the file DSN name selected in the File Data Sources list (or, you can enter a new file DSN name).

New button Adds a new file data source, If you click this button, the Create New Data Source dialog box appears with a list of drivers, Choose the driver for which you are adding a file DSN Click Next, and then specify the keywords for the file DSN.

A machine data source is specific to the machine you are working on and cannot be shared, This is the recommended ODBC data source when working with Project 2000, Click the Machine Data Source tab, shown in Figure 19.10, and set these options to we a machine data source:

Machine Data Sources list  A, list of all user and system DSNs that Includes the name and type, of each DSN. Double-clicking a DSN connects to the data source.

Data Source Name, Type, and Description columns in the Machine Data Source List Define the machine data sources available, Type can be User or System, User data sources are specific to a user on your machine, and System data sources can be shared by a users on your machine or by a system wide service.

New button Adds a new machine data source. If you click this button, the Create New Data Source dialog box appears with a list of drivers, Choose the drivers for which you are adding a user or system DSN, After you click Next, you can verify that the keywords for the DSN are correct.

Figure 19.10

                         Figure 19.10

Posted on November 26, 2015 in Importing and Exporting Project Data

Share the Story

Back to Top