Configuring RV2 for SQL or Oracle with IBM Datacap Taskmaster Capture

Configuring RV2 for SQL or Oracle with IBM Datacap

Taskmaster Capture

Abstract

How do I configure RV2 to use SQL or Oracle databases?

Answer

To configure RV2

1. On the machine hosting RV2, open the \Datacap\RV2 folder.


2. Backup reports.xml and then edit the original file.


3. Change dbtype="0" to:
   
   
   
   • dbtype="1" for SQL Server
   
   
   • dbtype="2" for Oracle
   
   
   
   


4. Apply for all applicable reports.


5. Save reports.xml.


6. Test and confirm the resolution.


7. If errors are encountered, review user permissions for the account running the Internet Information Services (IIS) application pool for RV2. The account must be able to access the datacap.xml and application (\\.app) files on the Taskmaster Server or wherever the application files are placed.