I have also used Minisoft for this.  It works very well.
We have several COBOL HP programs that dynamically update an SQL database.
We also use this as a migration tool.  The HP programs update the IMAGE and
the SQL keeping both in sync.  Later we will only update SQL and drop the
HP.

Charlie Cookston
Web Navigation LLC
317-259-1426
[log in to unmask]

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf
Of Mark Landin
Sent: Monday, November 17, 2008 12:10 PM
To: [log in to unmask]
Subject: Re: [HP3000-L] Linking MPE Cobol to MS Sql Server

you could write a listener service on windows tha could accept
messages from your COBOL program. this service would do all
communication with the SQL DB. your COBOL program would need t be able
to send messages via TCP/IP but that can be done.

overall, ODBC may be simpler. we use the minisoft product. good stuff.

On 11/17/08, Anderson, Russ <[log in to unmask]> wrote:
> We are a split shop... half COBOL/Image and half Microsoft (.NET, SQL,
> etc.)  We have an MPE
> application that needs real-time communication with an MS SQL Server
> database.  We need for
> the program to be able to insert a record into the SQL database and to
> be able to retrieve an updated
> copy of the record at a later point in time.  The insertion of the
> record fires a trigger to instigate a MS
> web-services call that will update the record.  We have both the
> web-services call and the COBOL
> application already in hand, the only missing piece would be the
> communications between the SQL
> database and the application.  This would need to be a real-time,
> multiple user connection.  Is there
> a way to do this without utilizing a 3rd party ODBC application?  If
> not, is there a definitive ODBC
> choice.
>
> Thanks in advance.
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>


-- 
"If hard work were such a wonderful thing, you'd think rich people
would have kept it all for themselves" - Lane Kirkland

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *