× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



A quick perusal of the MS docs suggest that msdrdaservice is so SQL Server
can talk to Db2.

To connect from IBM i to SQL Server all you need is a JDBC type 4 driver
for MS SQL Server...

Then you have to decide how to invoke it
- From a Java program
- through a DRDA Gateway
- Directly from RPG

I wouldn't recommend the last option.

For the second option, you've got the following choices...
purchasing and installing an external IBM Infosphere Federation Server
Or locally install on your i a DRDA Gateway product
- the commercial https://razlee.com/isecurity-db-gate/
- the open source https://sourceforge.net/projects/appserver4rpg/

HTH,
Charles


On Fri, Jan 12, 2024 at 12: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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.