Access an Oracle database on a different computer

Tue, 11 Jun 2002 13:33:11 -0700

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C21187.343152A0
Content-Type: text/plain;
	charset="iso-8859-1"

We are using PH 810c on Alpha OpenVMS to access both our RDB database and an
Oracle 7 database.  The TNSNAMES.ORA file on VMS contains the Oracle DB
descriptors (which resides on a Unix box) - our 810c dictionary is built
from a PDL:

create dictionary code not preloaded

File XXX_DATABASE &
Organization RELATIONAL &
Type ORACLE &
Null values allowed &
Open "ORACLE@<username>@<tnsnames-entry>/<password>" &
OWNER <oracle-schema>

This works like a charm for us and allows us to use PH against the Oracle
DB.

-----Original Message-----
From: Alfred Munksgard [mailto:a.munksgard@verizon.net]
Sent: Tuesday, June 11, 2002 11:41 AM
To: powerh-l@lists.swau.edu
Subject: Access an Oracle database on a different computer

Hello All,

I have a customer who is running PowerHouse 7.10.E6 on an Alpha and would
like to access an Oracle database on a different computer which is not
running PowerHouse. The two computers are networked via a T3 line. This
appears to be feasible, at least in Version 8.3, according to the PDL OPEN
Statement. The PowerHouse Web Component Configurations also states that
"your databases can be located on yet another machine on the network". I
would like to hear from anyone who can verify that this is true, and which
version of PowerHouse would be required. Thanks.

Alfred

------_=_NextPart_001_01C21187.343152A0
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.50.4807.2300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>We are 
using PH 810c on Alpha OpenVMS to access both our RDB database and an Oracle 7 
database.&nbsp; The TNSNAMES.ORA file on VMS contains the Oracle DB 
descriptors (which resides on a Unix box) - our 810c 
dictionary is built from a PDL:</DIV>
<DIV>&nbsp;</DIV>
<DIV>
create dictionary code not preloaded</DIV>
<DIV>File&nbsp;XXX_DATABASE &amp; Organization RELATIONAL &amp; Type ORACLE &amp; Null values allowed &amp; Open "ORACLE@&lt;username&gt;@&lt;tnsnames-entry&gt;/&lt;password&gt;" &amp; OWNER&nbsp;&lt;oracle-schema&gt;</DIV>
<DIV>&nbsp;</DIV>
<DIV>This works like a 
charm for us and allows us to use PH against the Oracle 
DB.</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
 <DIV class=OutlookMessageHeader dir=ltr align=left> -----Original Message----- From: Alfred Munksgard 
 [mailto:a.munksgard@verizon.net] Sent: Tuesday, June 11, 2002 11:41 
 AM To: powerh-l@lists.swau.edu Subject: Access an Oracle 
 database on a different computer </DIV>
 <DIV>
 Hello All,
 I have a customer who is running PowerHouse 7.10.E6 on an Alpha and would 
 like to access an Oracle database on a different computer which is not running 
 PowerHouse. The two computers are networked via a T3 line. This appears to be 
 feasible, at least in Version 8.3, according to the PDL OPEN Statement. The 
 PowerHouse Web Component Configurations also states that "your databases can 
 be located on yet another machine on the network". I would like to hear from 
 anyone who can verify that this is true, and which version of PowerHouse would 
 be required. Thanks.
 Alfred</DIV></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C21187.343152A0--