Date Posted:
Product: ChemBioOffice Enterprise
Product: ChemBioOffice Enterprise
Problem:
How do I search over more than one E-procurement database from ChemACX?
Solution:
The followin 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
- Copy
cfserver.ini
chemacx.ini
chemacx.udl
from config\AccessIni to config\
- Make sure chemacx.udl is pointing to the ChemACX database.
- Add ",chemacx2" without the quotation marks to
DB_NAMES
GLOBAL_SEARCH_DB
in cfserver.ini.
- Duplicate
config\chemacx2_Access.ini
chemacx2_Access.udl
and rename them to chemacx2.ini, chemacx2.udl
- Make sure chemacx2.udl is pointing to the second database.
- 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
- Copy
cfserver.ini
chemacx.ini
chemacx.udl
from config\AccessIni to config\
- Make sure chemacx.udl is pointing to the main database.
- Add ",chemacx2" without the quotation marks to
DB_NAMES
GLOBAL_SEARCH_DB
in cfserver.ini.
- Set USE_CS_SECURITY_APP=1.
- Duplicate
config\chemacx2_Oracle.ini
chemacx2_Oracle.udl
and rename them to chemacx2.ini, chemacx2.udl
- Make sure chemacx2.udl is pointing to the second database.
- 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
- Copy
cfserver.ini
chemacx.ini
chemacx.udl
from config\OraIni to config\
- Make sure chemacx.udl is pointing to the main database.
- Add ",chemacx2" without the quotation marks to
DB_NAMES
GLOBAL_SEARCH_DB
in cfserver.ini.
- Duplicate
config\chemacx2_Access.ini
chemacx2_Access.udl
and rename them to chemacx2.ini, chemacx2.udl
- Make sure chemacx2.udl is pointing to the second database.
- Go to
http://localhost/chemacx/default.asp?formgroup=gs_form_group&dbname=chemacx
for global search. Make sure ChemAcx2 is checked.
cfserver.ini
chemacx.ini
chemacx.udl
from config\OraIni to config\
DB_NAMES
GLOBAL_SEARCH_DB
in cfserver.ini.
config\chemacx2_Access.ini
chemacx2_Access.udl
and rename them to chemacx2.ini, chemacx2.udl
Comments
0 comments
Article is closed for comments.