sql from vms

[bruce@schuck.com]

Here is a very kludgy way to do some very limited
things. If you have SQL 2000 it is free. I only did
this as a test, but it worked.

SQL 2000 allows you to set up a url that you can
execute sql commands against it.

http://www.microsoft.com/sql/evaluation/features/access.asp

The next piece of the solution is lynx, which is a text
based web browser. You can get lynx for VMS.

So ... you can use lynx to send sql to SQL 2000. You
can even output result sets to a file and then parse
them.

Very kludgy. Very cheap. (If you have SQL 2000 or the
MSDE 2000) Very limited.

But it works.



On Thu, 05 Jun 2003 17:16:51 +0100, Chris Sharman wrote:

> 
> Anyone know how to access data in an MS SQL database
> from VMS 
> Powerhouse? Or VMS generally ?
> 
> 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.swau.edu
> Subscribe: "subscribe" in message body to
> powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe <password>" in message body
> to powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must
> be a subscriber.