OpenIngres + OpenROAD on Windows NT

From: Kim Bilde Fogh 

Paul Andrews wrote:
> 
> Tech support in the UK aren't keen on installation in the same directory. I
> have
> a fudge at the moment. OI 1.2 and OR 3.5 on different directories with the
> path
> extended to cover both. The icons for OR must be pointed to the correct
> path
> however and the log still has to go where II_SYSTEM is. In effect I have
> an II_SYSTEM and II_SYSTEM2.
> 
> Paul.
> 
> (at one time my installations shared the same path and it did seem to work
> but
> Tech support went tut, tut and I worried about applying patches).
> 
> ----------
> > From: John Bateson 
> > To: info-ingres@math.ams.org
> > Subject: Re: OpenROAD 3.5 and OpenIngres1.2 on WNT 3.5.1
> > Date: 11 October 1996 10:47
> >
> > I am in the middle of something very similar to this problem. I
> > believe that the current state is that Open Ingres and Open ROAD
> > must be installed under different directories and the result is
> > that the two are not interworkable at present. See the release
> > notes dated Mar 1996 for OR R 3.5/02(int.wnt/00)
> >
> > I also understand that there is a patch on the way.
> >
> > John Bateson
> > CLRC Daresbury
> >
> > Yusri Abdul Jabar wrote:
> > >
> > > Hi
> > >
> > > Does anybody try to install OpenROAD 3.5 and OpenIngres 1.2 for Windows
> > > NT 3.5.1 under the same directory? Please help me!
> > >
> > > I managed to startup OpenIngres 1.2 if no OpenROAD 3.5 had been
> > > installed.
> > > 1. When I put in (install) OpenROAD 3.5 under the same directory, I got
> > > an error when I try to startup OpenIngres 1.2, the error seems like I
> > > didn't setup the II_SYSTEM, II_JOURNALING, II_DUMP, II_LOG_FILE
> > > correctly, which I already set up.
> > > 2. When I try to startup OpenROAD, the system gives error to startup
> > > IIGCN and IIGCC which OpenROAD no need to startup because I was
> > > installed under the same machine and directory (host base).
> > > 3. I have no problem to run both OpenIngres 1.2 and OpenROAD 3.5 if
> > > there are client/server configuration (diffrent machine).
> > > 4. I managed to run OpenIngres 1.2 and OpenROAD 3.0 for WINNT 3.5.1
> > > under the same machine (host-base).
> > >
> > > My question is, is it a bug for OpenROAD 3.5 for WNT 3.5.1 or is it
> > > OpenROAD 3.5 only for client/server config.
> > >
> > > Thanks.Hi
I'll recommend installing OI an OR in different directories.
You can make it run from the same directory, but upgrades and
installation of patches may remove the carpet under Your feets,
and You may need to reinstall it all.

My recommandation:
Install OI as Ingres and make i run like a service.
Install OR as a different user in a different directory.
Move global ingres II_SYSTEM and PATH environments to user environments.
You can start/stop the OI-service as the 'different user'.
Make a small script that changes Your II_SYSTEM and PATH to OI.
This will give You access the OI tools, QBF, Report.....

You may give the 'different user' access to ingstart/ingstop
if You add an entry to the config.dat. Something like:

ii..privileges.user.:   SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED


Kim Fogh 
WM-data
Hermodsvej 22
8230 Aabyhoj
Denmark
(kifog@wmdata.com)
Ingres Q & A
To William's Home Page
Email William