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".
-
On the computer running the Project Reporter server, open the ODBC Data Sources
applet in the Control Panel.
-
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.
-
Click the
Add...
button, which opens the Create New Data Source window. In this window, select
the appropriate driver, and click the Finish button.
-
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.
-
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:
-
When choosing a driver, select "Microsoft Access Driver (*.mdb)".
-
When the ODBC Microsoft Access Setup window appears, enter a Data Source Name,
and click the
Select...
button to locate your .MPD file (note that the Select Database dialog only
displays .MDB files by default; you should change the file filter to "All Files
(*.*)" to locate .MPD files).
If you are creating a DSN for exporting PS7/PS8 projects, Click the
Create...
button instead of the
Select...
button, and specify the name of an .MDB file to create (the location of this
file is not important).
