PowerHouse 4GL and Oracle 9i -

[Peter Bateman]

Cora:



  Try this

    PDL

   FILE XYZ ORG RELATIONAL TYPE ORACLE

IF PDL accepts it then your version should run with ORACLE.

You will probably want an Oracle client set up on your VMS machine.
This lets you check things out with SQLPLUS.  Check with Oracle
on How to setup the connection between W2K and VMS.

After getting data with SQLPLUS, try setting up the
connection in PowerHouse. The dictionary manual pretty good
on explaining how this is done.

The cognos web site has information on OS and database versions
that are compalbe with which PowerHouse versiions.

Good luck,
Regards,
Peter


>From: "CORA VANDENDRIESSCHE" <cmvandendrie at cambrianc.on.ca>
>To: <powerh-l at sowder.com>
>Subject: PowerHouse 4GL and Oracle 9i -
>Date: Fri, 12 May 2006 07:09:08 -0400
>MIME-Version: 1.0
>Received: from sowder.com ([207.210.77.31]) by 
>bay0-mc11-f4.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 
>12 May 2006 04:31:01 -0700
>Received: from sowder.com (localhost [127.0.0.1])by sowder.com 
>(8.13.4/8.13.4/Debian-3sarge1) with ESMTP id k4CBAnfZ001730for 
><pfbcs at hotmail.com>; Fri, 12 May 2006 06:31:37 -0500
>Received: from MAILMAN.cambrianc.on.ca (mailman.cambrianc.on.ca 
>[38.112.107.5])by sowder.com (8.13.4/8.13.4/Debian-3sarge1) with ESMTP 
>idk4CBAQYE032340for <powerh-l at sowder.com>; Fri, 12 May 2006 06:10:38 -0500
>Received: from GROUPWISE1.cambrianc.on.ca (unverified [192.168.0.1]) 
>byMAILMAN.cambrianc.on.ca (Vircom SMTPRS 4.0.346.0) with ESMTP 
>id<B0003335289 at MAILMAN.cambrianc.on.ca> for <powerh-l at sowder.com>;Fri, 12 
>May 2006 07:09:38 -0400
>Received: from CCGWIA-MTA by GROUPWISE1.cambrianc.on.cawith 
>Novell_GroupWise; Fri, 12 May 2006 07:09:38 -0400
>X-Message-Info: txF49lGdW40T/hWwpNFQRLeuUFE4gayVSgVOkJncFr0=
>X-Mailer: Novell GroupWise Internet Agent 7.0 X-DRS-drsmilter-Version: 
>drsmilter CVS $Id: drsmilter.py,v 1.82 2006/04/04 13:38:59 drsmilter Exp $
>X-DRS-drsmilter-Version: drsmilter CVS $Id: drsmilter.py,v 1.82 2006/04/04 
>13:38:59 drsmilter Exp $
>X-BeenThere: powerh-l at lists.sowder.com
>X-Mailman-Version: 2.1.5
>Precedence: list
>List-Id: Cognos PowerHouse 4GL <powerh-l.lists.sowder.com>
>List-Unsubscribe: 
><http://lists.sowder.com/mailman/listinfo/powerh-l>,<mailto:powerh-l-request at lists.sowder.com?subject=unsubscribe>
>List-Archive: <http://lists.sowder.com/pipermail/powerh-l>
>List-Post: <mailto:powerh-l at lists.sowder.com>
>List-Help: <mailto:powerh-l-request at lists.sowder.com?subject=help>
>List-Subscribe: 
><http://lists.sowder.com/mailman/listinfo/powerh-l>,<mailto:powerh-l-request at lists.sowder.com?subject=subscribe>
>Errors-To: powerh-l-bounces+pfbcs=hotmail.com at lists.sowder.com
>Return-Path: powerh-l-bounces+pfbcs=hotmail.com at lists.sowder.com
>X-OriginalArrivalTime: 12 May 2006 11:31:01.0248 (UTC) 
>FILETIME=[8BDAE000:01C675B7]
>
>We are a LONG time powerhouse customer but have always used RMS records
>-
>
>We now have an new  Oracle 9i  application that we would like to have
>read-only access thru powerhouse to interface with RMS records -
>
>Our  environment is powerhouse is 7.10.E - VMS  7.2   -   Oracle 9i on
>Windows 2000
>
>Can I read the oracle tables thru powerhouse ?   If so, what needs to
>be done ?
>
>Thank you
>Cora
>
>


>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: &quot;subscribe&quot; in message body to 
>powerh-l-request at lists.sowder.com
>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
>list archive at Google.

_________________________________________________________________
Take advantage of powerful junk e-mail filters built on patented Microsoft® 
SmartScreen Technology. 
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.