MS SQL access (from VMS)

[Jeff Hoffman]

Hi

I know this is a stupid suggestion, but you could port the necessary
systems from VMS to Windows (using PH8.41c), the company I am contracting
to has just finished the code conversion part (of a faily significant
application) and have successfully duplicated most VMS dcl (except VMS
sorting).

Another option could be to develop a small system under windows to copy the
ms sql db data to a VMS data base system.

Like I said, a stupid suggestion.

Jeff

PS   Gee its great to have the list back!!!

At 09:23 AM 24-02-04 +0000, you wrote:
>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.
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" 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.
>
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
+ Jeff Hoffman                          + e-mail: wonicon@optushome.com.au  +
+ Director                              +                                   +
+ WoniCon Pty Ltd   (ABN 93 083 502 630)+                          ,-_|\    +
+ 21 Prices Circuit                     + voice: +61 2 9542 1527  /     \   +
+ Woronora    NSW     2232              +                         \_,-._*   +
+ AUSTRALIA                             + mobile: 040 790 3929         v    +
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+