Article 172770 of comp.os.vms:
In article <33B1B9D5.167E@triton.com>, Jay Olson <jjo@triton.com> writes:
>Are there any products which would allow a C program running on OpenVMS
>(Alpha) to access an SQL Server database running on a Windows NT (Intel)
>machine?
>-- 
>	- Jay Olson (jjo@triton.com)
>	Triton Software Group Ltd.


I searched for such a program myself...and was not able to find one...so 
I wrote a little c-program (not very good as I don't program much in C) to 
pull data from a SQL/MS-Access database via a web connection and an ODBC link.

It is pretty sloppy but it works...here are the hoops that I have to jump 
through just to get the data from an SQL server to a VMS System.

1.  Create an ODBC link on the NT server that allows access to the table 
    in the SQL or MS-Access database.

2.  Build the Microsoft IDC/HDX files needed to pull data via the ODBC 
    link via a web browser connection.  I created the HDX file to 
    insert a beginning and ending character(s) such as "$$" so that I could
    determine the beginning and ending of each record with the VMS C program.
    I also inserted the names of the fields as the first record, then for 
     each data record I placed quotes around each data field and used commas
     to separate each field...sort of a delimited record would be 
     created....I had to put the "$$" at then beginning and ending of 
     each record I wasn't able to figure out a good way to get the data
     returned without all of the data jammed togeather.

3.  Once you design your IDC/HDX files, you can test the return of the data 
    with any web client.

4.   On the VMS side, I wrote (using the UCX example) a little C-Program
     that issued a "get" to the IDC file...which executed the query and 
     retrieve the data via the HDX file.  the C-program then extracted 
     each record (based on the "$$" delimiters) and rewrote the file 
     into a nice formatted VMS -RMS file which was then usable by other
     applications.  

Again, this is probably swimming a lake when one could take a boat..but 
being desperate, It is the best I could come up with.  

I will be glad to send your the C-program and the HDX/IDC files 
if your would like

Charlie Cooper
University of Texas
School of Public Health.

PS, I am sure a good C-Programmer could really jazz this up so that perhaps
data could not only be retrieve but also inserted into an SQL database.