New to coding with Powerhouse
Fry, Mark
Mark.Fry@COGNOS.com
Wed, 12 Sep 2001 06:54:49 -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_01C13B79.581BC0E0
Content-Type: text/plain;
charset="iso-8859-1"
Hi Adam,
You'll probably find that there are a number of people on the list who have
lots of experience in using PowerHouse and InterBase - a few years back you
could buy copies of InterBase (called StarBase back then) from your friendly
Cognos salesperson, and for a time it was one of the few relational
databases that PowerHouse would talk to back then.
You will find that the version of PowerHouse you have will talk directly to
InterBase throught the InterBase OSRI interface - your PowerHouse code gets
converted to InterBase BLR requests and passed along to InterBase, so there
are no connectivity problems between PowerHouse and InterBase at all. These
days Borland seems to be concentrating more on the InterBase SQL interface,
but the OSRI interface is still there. If you wish to point other
applications at InterBase, you either have the option of writing your own
interface utility to connect to the OSRI interface [very difficult!], or use
one of the ODBC drivers available, which talk to the SQL interface. Even
back in the days of InterBase 4, there were a couple of ODBC drivers
available - I recall that you could (can?) get a unix version from the SCO
website - they called it SQL_Retriever - but that was a good while ago. The
Windows driver was from Visigenic, I think.
I also recall there was a product called InterClient, written by a (now Ex-)
Borland employee, which allowed Java access to InterBase too. I'm not sure
if this was developed against InterBase 4 or InterBase 5, though. Might be
worth a visit to the InterBase or Firebird web sites to find out?
If you upgrade to a later release of PowerHouse, you normally need to
recompile, so not having access to the source will likely be a problem.
Best regards,
Mark Fry
Cognos Limited
email: Mark.Fry@Cognos.com
-----Original Message-----
From: Adam Robertson [mailto:aroberts@orange.usyd.edu.au]
Sent: 12 September 2001 01:19
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_01C13B79.581BC0E0
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.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=270461308-12092001>Hi
Adam,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=270461308-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=270461308-12092001>You'll
probably find that there are a number of people on the list who have lots of
experience in using PowerHouse and InterBase - a few years back you could buy
copies of InterBase (called StarBase back then) from your friendly Cognos
salesperson, and for a time it was one of the few relational databases
that PowerHouse would talk to back then.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=270461308-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=270461308-12092001>You
will find that the version of PowerHouse you have will talk directly to
InterBase throught the InterBase OSRI interface - your PowerHouse code gets
converted to InterBase BLR requests and passed along to InterBase, so there
are no connectivity problems between PowerHouse and InterBase at all.
These days Borland seems to be concentrating more on the InterBase SQL
interface, but the OSRI interface is still there. If you wish to
point other applications at InterBase, you either have the option of writing
your own interface utility to connect to the OSRI interface [very
difficult!], or use one of the ODBC drivers available, which talk to the
SQL interface. Even back in the days of InterBase 4, there were a couple
of ODBC drivers available - I recall that you could (can?) get a unix version
from the SCO website - they called it SQL_Retriever - but that was a good while
ago. The Windows driver was from Visigenic, I
think.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=270461308-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=270461308-12092001>I also recall there was a product called
InterClient, written by a (now Ex-) Borland employee, which allowed Java access
to InterBase too. I'm not sure if this was developed against InterBase 4
or InterBase 5, though. Might be worth a visit to the InterBase or
Firebird web sites to find out?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=270461308-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=270461308-12092001>If you
upgrade to a later release of PowerHouse, you normally need to recompile, so not
having access to the source will likely be a problem.</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><SPAN class=270461308-12092001></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>B<SPAN class=270461308-12092001>est
regards,</SPAN></FONT></FONT></FONT></DIV>
<P><I><FONT face="Comic Sans MS" color=#000080>Mark Fry</FONT></I> <BR><FONT
face=Arial color=#808080 size=2>Cognos Limited</FONT> <BR><FONT face=Arial
size=2>email:<U> </U></FONT><U><FONT face=Arial color=#0000ff
size=2>Mark.Fry@Cognos.com</FONT></U> </P>
<BLOCKQUOTE dir=ltr 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> 12 September 2001
01:19<BR><B>To:</B> Powerhouse List (E-mail)<BR><B>Subject:</B> New to coding
with Powerhouse<BR><BR></FONT></DIV>
<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_01C13B79.581BC0E0--