Re: IBMi --> MS SQL Server Connection

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.