New to coding with Powerhouse
Deskin, Bob
Bob.Deskin@Cognos.COM
Wed, 12 Sep 2001 07:53:17 -0400
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_01C13B81.82957F20
Content-Type: text/plain;
charset="iso-8859-1"
Well, first of all, there's lots of support available. Certainly Cognos
remains firmly committed to PowerHouse and our Customer Support organization
can assist you. This list is also an invaluable resource. Here you will find
practical words of wisdom based on real-world experience.
Now to your questions.
As of versions after 8.2x, PowerHouse no longer supports InterBase. For
Tru64, the current version is 8.13D. If you want to use PowerHouse Web, the
versions are 8.23D4 and PH Web 2.23D3.
If you want to do Web applications, I heartily recommend PowerHouse Web. Of
course I'm a little biased being the Product Manager. However I think you'll
find lots of customers agree with me.
You can get at InterBase from PowerHouse Web on NT via ODBC. If you want to
run your web application on Tru64, then as of the next version you won't be
able to use InterBase. You can use Oracle or Sybase.
Moving from 8.13 to 8.23 or higher will require a recompile of the source
code. However, moving from version to version within series 8 should not and
typically does not require any coding changes. To recompile you will need
the source code.
Bob Deskin
PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
-----Original Message-----
From: Adam Robertson [mailto:aroberts@orange.usyd.edu.au]
Sent: September 11, 2001 8:19 PM
To: Powerhouse List (E-mail)
Subject: New to coding with Powerhouse
Hi all.
I am new to coding with powerhouse, and have been told by management that
there is not much in the way of support available. (ie, I have to work most
of it out myself)
We have Powerhouse ver 8.13d, with Interbase 4 as the database running on
Compaq Tru64 ver4.0f (on an Alpha box).
I understand that Powerhouse is no longer supported on Interbase 4.
My questions are:
1) Are there people on this list that will be able to provide me with
assistance in this enviroment?
And IF SO:
2) Does anyone know if it is possible to talk to the Interbase 4 database
with some sort of connectivity.
ie. Apparently ODBC is NOT available for Interbase 4, but is available
for Interbase 6
so maybe there is a way with JAVA or other product
(I want to populate web pages directly from the database)
3) We are looking to move to a newer database (ie a later version of
Interbase or Sybase) but apparently the older version of Powerhouse will not
operate with the newer database.
One alternative would be to move to a later version of Powerhouse as well,
but I assume that there would be major changes required to the source code
to do this.( It is possible that not all the source code is available).
Any Comments on this.
Thanks
Adam Robertson
Computer Systems Officer
University of Sydney, Orange (New South Wales, AUSTRALIA)
Phone: 02 6360 5967 Fax: 02 6360 5590
mailto:aroberts@orange.usyd.edu.au <mailto:aroberts@orange.usyd.edu.au>
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate, or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender by
e-mail promptly that you have done so. Thank You.
------_=_NextPart_001_01C13B81.82957F20
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.4522.1800" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=060594001-12092001>Well,
first of all, there's lots of support available. Certainly Cognos remains firmly
committed to PowerHouse and our Customer Support organization can assist you.
This list is also an invaluable resource. Here you will find practical words of
wisdom based on real-world experience.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=060594001-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=060594001-12092001>Now to
your questions.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=060594001-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=060594001-12092001>As of
versions after 8.2x, PowerHouse no longer supports InterBase. For Tru64, the
current version is 8.13D. If you want to use PowerHouse Web, the versions are
8.23D4 and PH Web 2.23D3.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=060594001-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=060594001-12092001>If you
want to do Web applications, I heartily recommend PowerHouse Web. Of course I'm
a little biased being the Product Manager. However I think you'll find lots of
customers agree with me.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=060594001-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=060594001-12092001>You
can get at InterBase from PowerHouse Web on NT via ODBC. If you want to run your
web application on Tru64, then as of the next version you won't be able to use
InterBase. You can use Oracle or Sybase.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=060594001-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=060594001-12092001>Moving
from 8.13 to 8.23 or higher will require a recompile of the source code.
However, moving from version to version within series 8 should not and typically
does not require any coding changes. To recompile you will need the source
code.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=060594001-12092001><FONT
face=Arial size=2></FONT></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=060594001-12092001><FONT
face=Arial size=2>Bob
Deskin
</FONT><BR><FONT face=Arial size=2>PowerHouse Web Product Manager, Application
Development Tools, Cognos Inc.</FONT> <BR><FONT face=Arial
size=2>bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178</FONT>
<BR><FONT face=Arial size=2>3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON
K1G 4K9 CANADA</FONT> </DIV></SPAN></FONT>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Adam Robertson
[mailto:aroberts@orange.usyd.edu.au]<BR><B>Sent:</B> September 11, 2001 8:19
PM<BR><B>To:</B> Powerhouse List (E-mail)<BR><B>Subject:</B> New to coding
with Powerhouse<BR><BR></DIV></FONT>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>Hi all.
</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>I am new to coding
with powerhouse, and have been told by management that there is not much in
the way of support available. (ie, I have to work most of it out
myself)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>We have Powerhouse
ver 8.13d, with Interbase 4 as the database running on Compaq Tru64 ver4.0f
(on an Alpha box).</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>I understand that
Powerhouse is no longer supported on Interbase 4.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>My questions
are:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>1) Are there
people on this list that will be able to provide me with assistance in this
enviroment?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>And IF
SO:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>2) Does anyone
know if it is possible to talk to the Interbase 4 database with some sort of
connectivity.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>
ie. Apparently ODBC is NOT available for Interbase 4, but is available for
Interbase 6</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>
so maybe there is a way with JAVA or other product</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>
(I want to populate web pages directly from the database)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>3) We are looking
to move to a newer database (ie a later version of Interbase or Sybase) but
apparently the older version of Powerhouse will not operate with the newer
database.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>One alternative
would be to move to a later version of Powerhouse as well, but I assume that
there would be major changes required to the source code to do this.( It is
possible that not all the source code is available).</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>Any Comments on
this.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001>Thanks</SPAN></FONT></DIV>
<P><FONT face=Arial size=2>Adam Robertson</FONT> <BR><FONT face=Arial
size=2>Computer Systems Officer</FONT> <BR><FONT face=Arial size=2>University
of Sydney, Orange</FONT> <FONT size=2><FONT face=Arial><SPAN
class=008480400-12092001>(New South Wales, AUSTRALIA)</SPAN><BR>Phone: 02 6360
5967 Fax: 02 6360 5590</FONT></FONT> <BR><FONT color=#000000><FONT
face=Arial size=2><A
href="mailto:aroberts@orange.usyd.edu.au">mailto:aroberts@orange.usyd.edu.au</A></FONT>
</FONT></P>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>
<P><FONT SIZE=2 FACE="Arial">This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate, or distribute it; do not open any attachments, delete it immediately from your system and notify the sender by e-mail promptly that you have done so. Thank You.</FONT></P>
------_=_NextPart_001_01C13B81.82957F20--