One Access File, Multiple Database

One Access File, Multiple Database

By Geert Van Hecke

We want to access different databases but without changing/duplicating the .acx files. We want the customer to choose the database that he wants to access.

Solution

Step 1 : Change logon screen to add an extra field ‘Client’

The ‘Client’ will be used to connect to a database.

Step 2 : Administration console

Change site.wfs to pass the &IBIC_user (‘Client’) in Step 1

Change cgivars.wfs : &IBIC_user is used as report user

Step 3 : Create a user on the windows server for each ‘client’

Step 4 : Create a User Profile in the Webfocus console for each user on the windows server

This user profile contains a default connection to the customer’s database :

In the .acx files, we don’t use a connection !

SEGNAME=VW_REPORT_OBJ001, TABLENAME=dbo.VW_REPORT_OBJ001, KEYS=0, $

Problem solved !

If any questions, please contact Geert at geert.van.hecke@securex.be.