sql from vms

Wed, 11 Jun 2003 10:34:11 -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_01C33026.86560260
Content-Type: text/plain

Hi Chris,

Sorry it's taken me a while to jump in on this one...

The only relational databases directly supported by PowerHouse on OpenVMS
are Oracle Rdb and Oracle 7/8/8i/9i (depending on the version of
PowerHouse).

Hence, the only way that I can think of for you to access a MS SQL Server
database from PowerHouse on OpenVMS would be to use the Oracle Transparent
Gateway for MS SQL Server.

This requires that you have Oracle on your OpenVMS box and the gateway on
your SQL Server box. The gateway make the SQL Server database look just like
an Oracle database, and so PowerHouse thinks it's talking to Oracle when in
fact it's accessing a SQL Server database.

Best regards,
Conrad

Conrad Whittall
Solutions Architect, Global Customer Services
Cognos Incorporated, 3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada

-----Original Message-----
From: Chris Sharman [mailto:chris.sharman@ccagroup.co.uk]
Sent: 11 June 2003 07:07
To: powerh-l@lists.swau.edu
Subject: Re: sql from vms

Edis, Robert wrote:
> I think EasySoft (www.easysoft.com) may have a solution for you with it
ODBC
> to ODBC bridge software.

Looking at it (as well as freetds & unixodbc).

Can VMS Powerhouse (either 7.10G or the latest & greatest 8.xx) talk to 
foreign (MS SQL) databases ?

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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =

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_01C33026.86560260
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.89">
<TITLE>RE: sql from vms</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Hi Chris,</FONT>
</P>

<P><FONT SIZE=3D2>Sorry it's taken me a while to jump in on this =
one...</FONT>
</P>

<P><FONT SIZE=3D2>The only relational databases directly supported by =
PowerHouse on OpenVMS are Oracle Rdb and Oracle 7/8/8i/9i (depending on =
the version of PowerHouse).</FONT></P>

<P><FONT SIZE=3D2>Hence, the only way that I can think of for you to =
access a MS SQL Server database from PowerHouse on OpenVMS would be to =
use the Oracle Transparent Gateway for MS SQL Server.</FONT></P>

This requires that you have Oracle on your OpenVMS =
box and the gateway on your SQL Server box. The gateway make the SQL =
Server database look just like an Oracle database, and so PowerHouse =
thinks it's talking to Oracle when in fact it's accessing a SQL Server =
database.

<P><FONT SIZE=3D2>Best regards,</FONT>
<BR><FONT SIZE=3D2>Conrad</FONT>
</P>

<P><FONT SIZE=3D2>Conrad Whittall</FONT>
<BR><FONT SIZE=3D2>Solutions Architect, Global Customer Services</FONT>
<BR><FONT SIZE=3D2>Cognos Incorporated, 3755 Riverside Drive, Ottawa, =
Ontario, K1G 4K9, Canada</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Chris Sharman [<A =
HREF=3D"mailto:chris.sharman@ccagroup.co.uk">mailto:chris.sharman@ccagro=
up.co.uk</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: 11 June 2003 07:07</FONT>
<BR><FONT SIZE=3D2>To: powerh-l@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Subject: Re: sql from vms</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Edis, Robert wrote:</FONT>
<BR><FONT SIZE=3D2>&gt; I think EasySoft (www.easysoft.com) may have a =
solution for you with it ODBC</FONT>
<BR><FONT SIZE=3D2>&gt; to ODBC bridge software.</FONT>
</P>

<P><FONT SIZE=3D2>Looking at it (as well as freetds &amp; =
unixodbc).</FONT>
</P>

<P><FONT SIZE=3D2>Can VMS Powerhouse (either 7.10G or the latest &amp; =
greatest 8.xx) talk to </FONT>
<BR><FONT SIZE=3D2>foreign (MS SQL) databases ?</FONT>
</P>

<P><FONT SIZE=3D2>Thanks,</FONT>
<BR><FONT SIZE=3D2>Chris</FONT>
</P>
<BR>
<BR>

<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
--------</FONT>
</P>

Any views expressed in this message are those of the =
sender and not
 necessarily those of CCA Group.&nbsp; The =
unauthorized use, disclosure,
 copying or alteration of this message is =
forbidden.&nbsp; 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.&nbsp; 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.
 =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D

<P><FONT SIZE=3D2>This message may contain privileged and/or =
confidential information.&nbsp; 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.&nbsp; Thank you.</FONT></P>

</BODY>
</HTML>
------_=_NextPart_001_01C33026.86560260--