MS SQL access (from VMS)
Robert Edis
robeconsult@sbcglobal.net
Tue, 24 Feb 2004 10:12:01 -0800 (PST)
--0-475090789-1077646321=:62490
Content-Type: text/plain; charset=us-ascii
G'day Jeff
That's NOT a bad suggestion. If acopy of the required database tables that exist in SQL Server could be created in Rdb then SQL Server DTS packages could be used to copy the data from SQL Server to Rdb and visa versa via scheduled SQL Server Agent jobs.
If the data in SQL Server has to be updated from the PH processes how quickly does the new/updated data have to be in the SQL Server tables?
If the data in the SQL Server database is only used for reporting it would be a somple task.
Does anyone know if a SQL Server DTS package can write to RMS files?
Blue
Jeff Hoffman <wonicon@optushome.com.au> wrote:
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 /* 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
" 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 +
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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-475090789-1077646321=:62490
Content-Type: text/html; charset=us-ascii
<DIV>G'day Jeff</DIV>
<DIV> </DIV>
<DIV>That's NOT a bad suggestion. If acopy of the required database tables that exist in SQL Server could be created in Rdb then SQL Server DTS packages could be used to copy the data from SQL Server to Rdb and visa versa via scheduled SQL Server Agent jobs.</DIV>
<DIV> </DIV>
<DIV>If the data in SQL Server has to be updated from the PH processes how quickly does the new/updated data have to be in the SQL Server tables?</DIV>
<DIV>If the data in the SQL Server database is only used for reporting it would be a somple task.</DIV>
<DIV> </DIV>
<DIV>Does anyone know if a SQL Server DTS package can write to RMS files?</DIV>
<DIV> </DIV>
<DIV>Blue<BR><BR><B><I>Jeff Hoffman <wonicon@optushome.com.au></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Hi<BR><BR>I know this is a stupid suggestion, but you could port the necessary<BR>systems from VMS to Windows (using PH8.41c), the company I am contracting<BR>to has just finished the code conversion part (of a faily significant<BR>application) and have successfully duplicated most VMS dcl (except VMS<BR>sorting).<BR><BR>Another option could be to develop a small system under windows to copy the<BR>ms sql db data to a VMS data base system.<BR><BR>Like I said, a stupid suggestion.<BR><BR>Jeff<BR><BR>PS Gee its great to have the list back!!!<BR><BR>At 09:23 AM 24-02-04 +0000, you wrote:<BR>>Deskin, Bob wrote:<BR>><BR>>> ODBC access is available on Windows NT/2000/XP (PH 8.41 or Axiant 3.4). <BR>>> It is not available in 8.40. You can get to RDB on an OpenVMS box from <BR>>> your Windows box running PowerHouse/PowerHouse Web/Axiant but that's not <BR>>>
what's desired. I don't know of any way to get from an OpenVMS box to <BR>>> SQL Server. You would need something from Oracle that would hook into a <BR>>> SQL Server database.<BR>><BR>>I believe I've heard something along these lines before. Shame. I'd <BR>>hoped that the 'common core' would provide odbc, sql, or similar. <BR>>Freetds & its odbc support appears pretty good. The Oracle option is <BR>>quite dear I believe.<BR>><BR>>Jari mentioned a migration. We've installed MS Navision to replace our <BR>>old Unix Accounts package, and some of the stock system, but it can't <BR>>replace all our VMS applications, and we don't plan to try. The <BR>>splitting of our data across the two platforms will doom Powerhouse here <BR>>though, long term, if it can't access both. If it needs a lot more money <BR>>to achieve it, I suspect other tools will look more attractive.<BR>><BR>>BDO did the initial Navision installation &
support, less than <BR>>competently IMO. The contract is now with Alpha Landsteinar, who appear <BR>>to know their arse from their elbow, although it's early days.<BR>><BR>>Chris<BR>><BR>>> -----Original Message-----<BR>>> <BR>>> I believe I asked about this a couple of years ago and Cognos said<BR>>> it couldn't be done. BUT as ODBC is one of the database access<BR>>> options in the PHD (at least in 8.4) I don't see why you couldn't<BR>>> connect to a SQL Server database via an appropriate ODBC driver.<BR>>> <BR>>> Blue<BR>>> <BR>>> */Chris Sharman <CHRIS.SHARMAN@CCAGROUP.CO.UK>/* wrote:<BR>>> <BR>>> 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<BR>>> believe that<BR>>> also supports ODBC, db-lib, and ct-lib.<BR>>> Anyone know if it's possible to use Powerhouse (on VMS) for<BR>>> 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>><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<BR>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.<BR>><BR>+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+<BR>+ Jeff Hoffman + e-mail: wonicon@optushome.com.au +<BR>+ Director + +<BR>+ WoniCon Pty Ltd (ABN 93 083 502 630)+ ,-_|\ +<BR>+ 21 Prices Circuit + voice: +61 2 9542 1527 / \ +<BR>+ Woronora NSW 2232 + \_,-._* +<BR>+ AUSTRALIA + mobile: 040 790 3929 v
+<BR>+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-<BR>+<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-475090789-1077646321=:62490--