MS SQL access (from VMS)

Thu, 26 Feb 2004 00:31:41 +1100

Robert

To quote from boB Deskin:

<fontfamily><param>Arial</param><color><param>0000,0000,ffff</param><smaller>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.

</smaller></color></fontfamily>

PH 841c on Windows can access MS SQL server, that is the base DB for our
porting from VMS so if what Bob said is true and you have the licences
then you should be able to directly transfer from MS Sql on windows to
RDB on VMS.

Jeff

At 03:16 PM 24-02-04 -0800, you wrote: 

>>>>

<excerpt>Because PH can't read/write from/to SQL Server from OpenVMS.

<bold><italic>Jeff Hoffman <<wonicon@optushome.com.au></italic> wrote: 

<excerpt>Howdy Blue

Whats wrong with using PH to do the copy?

Jeff 

At 10:12 AM 24-02-04 -0800, you wrote: 

>>>>

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

>> reporti! ng 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.

<<<<<<<<<<<<<<<<

</excerpt>

</bold></excerpt><bold><<<<<<<<

</bold>