How do I search over more than one E-procurement database from ChemACX?

How do I search over more than one E-procurement database from ChemACX?

The following instructions step you through the configuration necessary for searching over your personal E-procurement database as well as CambridgeSoft's ChemACX.

Case 1: ChemACX database in Microsoft Access, secondary database in Microsoft Access

1. After backing up a copy of the files in your config directory, copy
   cfserver.ini
   chemacx.ini
   chemacx.udl
   from config\AccessIni to config\
    
2. Make sure chemacx.udl is pointing to the ChemACX database.
3. Add ",chemacx2" without the quotation marks to
   DB_NAMES
   GLOBAL_SEARCH_DB
   in cfserver.ini.
    
4. Copy
   config\chemacx2_Access.ini
   config\chemacx2_Access.udl
   to config\globalini and rename them
   chemacx2.ini
   chemacx2.udl
    
5. Make sure chemacx2.udl is pointing to the second database.
6. Make sure the path pointing to the MST file in chemacx2.ini is correct.
7. Go to http://localhost/chemacx/default.asp?formgroup=gs_form_group&dbname=chemacx to perform a global search. Make sure ChemAcx2 is checked.

Case 2: ChemACX database in Microsoft Access, secondary database in Oracle

1. Copy
   cfserver.ini
   chemacx.ini
   chemacx.udl
   from config\AccessIni to config\
    
2. Make sure chemacx.udl is pointing to the main database.
3. Add ",chemacx2" without the quotation marks to
   DB_NAMES
   GLOBAL_SEARCH_DB
   in cfserver.ini.
    
4. Set USE_CS_SECURITY_APP=1. Copy
   config\chemacx2_Access.ini
   config\chemacx2_Access.udl
   to config\globalini and rename them
   chemacx2.ini
   chemacx2.udl
   
5. Make sure chemacx2.udl is pointing to the second database.
6. Go to http://localhost/chemacx/default.asp?formgroup=gs_form_group&dbname=chemacx to perform global search. Make sure ChemAcx2 is checked.

Case 3: ChemACX database in Oracle, secondary database in Microsoft Access

1. Copy
   cfserver.ini
   chemacx.ini
   chemacx.udl
   from config\OraIni to config\
    
2. Make sure chemacx.udl is pointing to the main database.
3. Add ",chemacx2" without the quotation marks to
   DB_NAMES
   GLOBAL_SEARCH_DB
   in cfserver.ini.
    
4. Duplicate
   config\chemacx2_Access.ini
   chemacx2_Access.udl
   and rename them to chemacx2.ini, chemacx2.udl
    
5. Make sure chemacx2.udl is pointing to the second database.
6. Go to http://localhost/chemacx/default.asp?formgroup=gs_form_group&dbname=chemacx for global search. Make sure ChemAcx2 is checked.

Case 4: ChemACX database in Oracle, secondary database in Oracle