MS SQL access (from VMS)
Deskin, Bob
Bob.Deskin@Cognos.COM
Mon, 23 Feb 2004 18:35:16 -0500
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_01C3FA65.AFFB0D54
Content-Type: text/plain
ODBC access is available on Windows NT/2000/XP (PH 8.41 or Axiant 3.4). It
is not available in 8.40. You can get to RDB on an OpenVMS box from your
Windows box running PowerHouse/PowerHouse Web/Axiant but that's not what's
desired. I don't know of any way to get from an OpenVMS box to SQL Server.
You would need something from Oracle that would hook into a SQL Server
database.
Bob Deskin
Product Manager, Application Development Tools
Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA
bob.deskin@cognos.com (613) 738-1338 ext 7268
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Robert Edis
Sent: February 23, 2004 6:22 PM
To: powerh-l@lists.sowder.com
Subject: Re: MS SQL access (from VMS)
G'day Chris
I believe I asked about this a couple of years ago and Cognos said it
couldn't be done. BUT as ODBC is one of the database access options in the
PHD (at least in 8.4) I don't see why you couldn't connect to a SQL Server
database via an appropriate ODBC driver.
Blue
Chris Sharman <chris.sharman@ccagroup.co.uk> wrote:
We've now got a Windows SQL db storing lots of data.
We can run SQL queries on it from VMS using freetds, and I believe that
also supports ODBC, db-lib, and ct-lib.
Anyone know if it's possible to use Powerhouse (on VMS) for reporting on
this database, as if it was local Rdb or whatever ?
Presumably quiz uses SQL or something to talk to databases ?
How do we persuade it to connect through freetds ?
Thanks,
Chris
-----------------------------------------------------------------------
Any views expressed in this message are those of the sender and not
necessarily those of CCA Group. The unauthorized use, disclosure,
copying or alteration of this message is forbidden. The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed. Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe " in message body to
powerh-l-request@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.
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
promptly by e-mail that you have done so. Thank you.
------_=_NextPart_001_01C3FA65.AFFB0D54
Content-Type: text/html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<META content="MSHTML 5.50.4937.800" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=154363023-23022004><FONT face=Arial color=#0000ff size=2>ODBC
access is available on Windows NT/2000/XP (PH 8.41 or Axiant 3.4). It is not
available in 8.40. You can get to RDB on an OpenVMS box from your Windows
box running PowerHouse/PowerHouse Web/Axiant but that's not what's desired. I
don't know of any way to get from an OpenVMS box to SQL Server. You would need
something from Oracle that would hook into a SQL Server
database.</FONT></SPAN></DIV>
<DIV><SPAN class=154363023-23022004>
<P><FONT face=Arial size=2>Bob
Deskin
</FONT><BR><FONT face=Arial size=2>Product Manager</FONT><FONT face=Arial
size=2>,</FONT> <FONT face=Arial size=2>Application Development Tools</FONT>
<BR><FONT face=Arial size=2>Cognos Inc.</FONT><FONT face=Arial size=2></FONT>
<FONT face=Arial size=2>3755 Riverside Drive</FONT><FONT face=Arial
size=2>,</FONT> <FONT face=Arial size=2>Ottawa ON K1G 4K9 CANADA</FONT>
<BR><FONT face=Arial size=2>bob.deskin@cognos.com</FONT><FONT face=Arial
size=2></FONT> <FONT face=Arial size=2>(613) 738-1338 ext</FONT> <FONT
face=Arial size=2>7268</FONT> </P></SPAN></DIV>
<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>
powerh-l-admin@lists.sowder.com [mailto:powerh-l-admin@lists.sowder.com]<B>On
Behalf Of </B>Robert Edis<BR><B>Sent:</B> February 23, 2004 6:22
PM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> Re: MS SQL
access (from VMS)<BR><BR></FONT></DIV>
<DIV>G'day Chris</DIV>
<DIV> </DIV>
<DIV>I believe I asked about this a couple of years ago and Cognos said it
couldn't be done. BUT as ODBC is one of the database access options in
the PHD (at least in 8.4) I don't see why you couldn't connect to a SQL Server
database via an appropriate ODBC driver.</DIV>
<DIV> </DIV>
<DIV>Blue<BR><BR><B><I>Chris Sharman
<chris.sharman@ccagroup.co.uk></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">We've
now got a Windows SQL db storing lots of data.<BR>We can run SQL queries on
it from VMS using freetds, and I believe that <BR>also supports ODBC,
db-lib, and ct-lib.<BR>Anyone know if it's possible to use Powerhouse (on
VMS) for reporting on <BR>this database, as if it was local Rdb or whatever
?<BR>Presumably quiz uses SQL or something to talk to databases ?<BR>How do
we persuade it to connect through freetds
?<BR><BR>Thanks,<BR>Chris<BR><BR><BR>-----------------------------------------------------------------------<BR><BR>Any
views expressed in this message are those of the sender and
not<BR>necessarily those of CCA Group. The unauthorized use,
disclosure,<BR>copying or alteration of this message is forbidden. The
contents of<BR>this message may be confidential and/or privileged, copyright
CCA Group<BR>and are intended solely for the use of the individual or entity
to whom<BR>they are addressed. Whilst this message has been scanned, CCA
Group<BR>cannot guarantee that it is virus free or compatible with your
systems<BR>and accepts no responsibility for any loss or damage arising from
its<BR>use. The recipient is advised to run their own anti-virus software.
If<BR>you receive this message in error please
contact<BR>postmaster@ccagroup.co.uk immediately, destroy any copies and
delete it<BR>from your computer systems.<BR>= = = = = = = = = = = = = = = =
= = = = = = = = = = = =<BR>Mailing list:
powerh-l@lists.sowder.com<BR>Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com<BR>Unsubscribe: "unsubscribe <PASSWORD>"
in message body to
powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This
list is closed, thus to post to the list you must be a
subscriber.</BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
<BR>
<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 promptly by e-mail that you have done so. Thank you.</FONT></P>
------_=_NextPart_001_01C3FA65.AFFB0D54--