Install Database Connectivity Tools
Contents
SQL Server or Oracle
Note: Database connectivity tools are ONLY required on the application server and the web server (if that is a different computer). Client computers do NOT require database connectivity tools.
BPC Risk Manager uses ActiveX Data Objects (ADO) / MDAC to access data stored in a SQL database. The tools for this connectivity method are required on the servers.
Whether you are using SQL Server (any version) or Oracle (any version) you must have the database connectivity tools installed on the application server and the web server. Most Windows operating systems will include the correct versions by default. Some of the older MS Windows versions will require an update. If your MDAC/ADO version is later than the those listed here, that will be fine. We are only concerned that the correct MINIMUM version is on the relevant computer.
Windows 2000 or NT
If you are using Windows 2000 or earlier as your Application Server Computer OS…
- Install MDAC version 2.7 or MDAC 2.8 (or later) from the CD
Install MDAC version 2.7 or 2.8 from CD by running install file: [RMInstallDir]\DatabaseTools\MDAC\MDAC 2_7\ MDAC_TYP.EXE
(Note: Your CD may have MDAC 2.8 instead, look in [RMInstallDir]\DatabaseTools\MDAC\MDAC 2_8\ )
Optional: If you would like to know what version of MDAC you are running before performing this installation then run the MDAC component checker program first. Extract the MDAC component checker program from file ‘cc.exe’ available in folder ‘\Database Tools\MDAC\Component Checker’.
Windows XP, Vista, Windows 2003, Windows 2008
Versions of Windows XP, Vista, 2003 or later include the correct minimum MDAC version by default so if using Windows XP / Vista / Server 2003 or later, this step can be skipped..
Oracle
If you are using an Oracle Database & BPC RiskManager Express (V5)…
- Install Database Client Tools (ORACLE VERSION ONLY)
(This step applies ONLY to BPC RiskManager V5 and BPC RiskManager Express)
A separate installation of database client tools is typically only required when the database is housed on a separate network server. The risk database can be installed on the same network server as the Risk Manager server application or on another network server. The Risk Manager Data Server and Risk Mail Manager applications require database client tools in order to access the risk database(s).
Oracle sites installing database client tools need to select ‘Oracle Programmer’ and ‘Oracle Windows Interfaces’ components in order to install the necessary Oracle ADO database provider: ‘Oracle Provider for OLE DB’.
NOTE: You can skip the Oracle Tools installation if you are not using an Oracle Database Server.
