Re: IBMi --> MS SQL Server Connection

If you want to do it directly from an RPG program or sql procedure you may
want to look at ARDGATE. I've never used it. Not my product. Basically
it's a driver to put something in an exit to allow you to simply sql MS
SQL. It's from Dieter Bender.

On Fri, Jan 12, 2024 at 2:47 PM Javier Sanchez <
javiersanchezbarquero@xxxxxxxxx> wrote:

I confess I have never done this before.
I am writing a CGI program, where I will receive a request asking to search
for and return two images, may be png, jpeg, bmp, etc.

These images live in a SQL Server table, I understand it's one column for
each image, and I also understand that these should be of type BLOB.

I have found quite a few documents that show how to configure the IBM i,
and it also says that on the side of the MS SQL Server it is required that
some service called msdrdaservice be up and running. I have been unable to
get this part of the process done, because I depend on the team that's on
the other side of the IBM i.

Even so, I think we're close to getting it. But I just don't know how to
manage the query that's going to give me back the two BLOB columns
containing the images. Moreover, I have never returned, say, a multipart
http response. I have read material but I need to do that by myself now.
:-D

I would greatly appreciate comments, suggestions, recommendations,
everything.

TIA

Javier.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.