MS SQL access (from VMS)

[Chris Sharman]

Deskin, Bob wrote:

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

I believe I've heard something along these lines before. Shame. I'd 
hoped that the 'common core' would provide odbc, sql, or similar. 
Freetds & its odbc support appears pretty good. The Oracle option is 
quite dear I believe.

Jari mentioned a migration. We've installed MS Navision to replace our 
old Unix Accounts package, and some of the stock system, but it can't 
replace all our VMS applications, and we don't plan to try. The 
splitting of our data across the two platforms will doom Powerhouse here 
though, long term, if it can't access both. If it needs a lot more money 
to achieve it, I suspect other tools will look more attractive.

BDO did the initial Navision installation & support, less than 
competently IMO. The contract is now with Alpha Landsteinar, who appear 
to know their arse from their elbow, although it's early days.

Chris

>     -----Original Message-----
>      
>     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 ?



-----------------------------------------------------------------------

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.