PowerHouse and RMS/Oracle Databases

[Edis, Bob]

Why don't they just put Oracle Rdb on the VMS box?

Use as much embedded SQL as possible with the Oracle (non-Rdb) database
access.

Can Oracle 7/8 ONLY be accessed by PH using SQL*Net?  Can other ODBC drivers
be used?  If so then why can't PH 7.10 access Oracle as a standard ODBC
database rather than a SQL*Net database?

Blue

-----Original Message-----
From: Trevor Dockeray [mailto:Trevor.Dockeray@Lightsout.co.uk]
Sent: Tuesday, May 14, 2002 6:13 AM
To: PowerHouse List (E-mail)
Subject: PowerHouse and RMS/Oracle Databases


Hi All

Here is a question for those with experience of:
*	Compaq Alpha,
*	Running OpenVMS 7.1-1H1,
*	With PowerHouse (7.10G2 at present - we realise that this will need
to be upgraded to 8.30D to use Oracle) application, 
*	Using RMS data files,
*	And Oracle!

We will need to read and write to an Oracle Database on a 'box' running a
'flavour' of Unix (yes - for those of you who may have guessed, this machine
and operating system have not yet been completely specified/purchased yet)

With the added 'feature' of having the PowerHouse application server some
distance away (100's of miles) to the Oracle Application server over a 2mb
network link.

I understand from Cognos we will need to upgrade to PowerHouse 8.30D (and
recompile the application), install an PowerHouse Oracle licence, install an
Oracle user licence for the Alpha and configure necessary TNS.ORA file,
sequel net etc...

Although this will probably work where the RMS files and Oracle database are
on the same machine, we have no idea if it will work on between two
machines/two operating systems/two locations over a 2mb WAN...

Does anyone have any experience of this?

Will it work?

How well will it perform?

TIA

Regards,


Trevor Dockeray

Lightsout Computer Services Limited
Providers of Technical and Business Continuity Services 

Phone:	08707 274343
Fax:	08707 274342
Mobile:   07957 881867
E-Mail:   trevor.dockeray@lightsout.co.uk
Web:       http://www.lightsout.co.uk

The information contained in this e-mail is confidential and is intended for
the exclusive use of the individual(s) or organisation specified above.  Any
unauthorised dissemination or copying of this e-mail, or misuse or wrongful
disclosure of information contained in it, is strictly prohibited and may be
illegal.  Please notify the sender by phone or fax immediately should you
have received this e-mail in error.
Registered Office:  The Data Centre, Leicester Road, LUTTERWORTH,
Leicestershire, LE17 4HD
Registered in England No. 2852620


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.