RE: IBMi --> MS SQL Server Connection

I vaguely recall doing a POC using the "RDB Connect" product from DBU. Never came to fruition in production though.

I know I used to use DBU to manipulate a SQL Server database running on a Windows server. Worked well.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power




-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Charles Wilt
Sent: Friday, January 12, 2024 3:11 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: IBMi --> MS SQL Server Connection

ARDGATE is part of the AppServer4RPG I provided a link to...

Charles

On Fri, Jan 12, 2024 at 2:06 PM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

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.

--
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.