MS SQL access (from VMS)

[Robert Edis]

--0-591798357-1077578520=:8564
Content-Type: text/plain; charset=us-ascii

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.
--0-591798357-1077578520=:8564
Content-Type: text/html; charset=us-ascii

<DIV>G'day Chris</DIV>
<DIV>&nbsp;</DIV>
<DIV>I believe I asked about this a couple of years ago and Cognos said it couldn't be done.&nbsp; 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>&nbsp;</DIV>
<DIV>Blue<BR><BR><B><I>Chris Sharman &lt;chris.sharman@ccagroup.co.uk&gt;</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>
--0-591798357-1077578520=:8564--