Contents : Administering Project Reporter : Managing data sources and projects
Creating an ODBC Data Source Name (DSN)

Note: As of Version 3.0 of Project Reporter, this procedure is no longer required for loading projects stored in the MPD format (as long as there is only one project per file) — you can load MPD files directly, the same way you would load MPX or PRX files. The same applies to Scitor PS7/PS8 projects saved in .MDB files.

Creating an ODBC Data Source Name for an Oracle or SQL Server database

In order to use Project Reporter with project data stored in an Oracle or SQL Server database, you must first create an ODBC Data Source Name (DSN) on the computer running the Project Reporter server, unless you have already created one for other purposes. The following procedure assumes that you are running the Project Reporter server under Windows 95, 98, 2000, NT, or XP.

Note: Before creating an ODBC data source for an Oracle database, you must install the Oracle client software on the computer where you are creating the data source. Also, when creating a data source, you should select the "Microsoft ODBC for Oracle" driver instead of the "Oracle ODBC Driver".

  1. On the computer running the Project Reporter server, open the ODBC Data Sources applet in the Control Panel.
  2. Select the System DSN tab, and check to see if a data source has already been configured for your database. If a data source already exists, you may wish to skip the remaining steps and use it.
  3. Click the Add... button, which opens the Create New Data Source window. In this window, select the appropriate driver, and click the Finish button.
  4. In the following dialogs, enter the appropriate settings for your database, consulting a system administrator if necessary. During this process, you will be given an opportunity to make a test connection to the database.
  5. When you have finished configuring the new data source, its name should appear in the list of System data sources.
After creating the ODBC DSN, you need to create a link to it in Project Reporter, using the Add Data Source link on the Projects page in the administration interface.

Creating an ODBC Data Source Name for an .MPD file or .MDB file for PS7/PS8

If you are creating a DSN for an .MPD file containing multiple projects, use the above procedure, but with the following changes: