Re: DRDA and Azure SQL Server

I believe that ODBC, JDBC, .NET, etc. all are on top of DRDA.

I remember this because the Synapse IP Client (now Trilobyte IP Client)
file transfer (developed by [1]Joe Frank - father of IBM I emulation)
uses
DRDA directly.

J
On 2/4/2022 10:45 AM, Vern Hamberg via MIDRANGE-L wrote:

Hi Dean

I'd say the main problem is that no one has a DRDA provider to use for
this - I'm not sure even about IBM. They have .Net and ODBC and JDBC
stuff in the Access Client Solutions Application Package.

DRDA is like ODBC, you need an application that uses the DRDA
functions
to work with data remotely. Microsoft used to have a DRDA provider, so
did Oracle - but nothing more that I know of. And you do NOT want the
consultants to write one.

They can connect directly with ODBC or .Net or JDBC - easy-peasy! But
why not use REST APIs? Azure uses them all the time.

HTH
Vern

On 2/4/2022 12:37 PM, Dean Eshleman wrote:

Hi,

We are on 7.3 of IBM i. We are working on a project where an
application in Azure will need to update some tables on the IBM i.
Our initial thought was to create REST API's on the IBM I and have
the
Azure application call them. We have experience with REST API's, so
we understand how that would work. The consultants we are working
with (Windows background) ran across DRDA and wondered if they could
use that to connect directly to the database on the IBM I and skip
the
REST API. The thinking being, that would be less work. I did some
reading about DRDA, but it wasn't very clear to me how it works.
Does
anyone have experience using DRDA in this manner? I guess I would
also be interested in reasons why this may not be a good idea. TIA

Dean Eshleman
Software Development Architect
Everence

1110 North Main Street
PO Box 483
Goshen, IN 46527
(800) 348-7468 ext. 3528
(574) 533-9515 ext. 3528
[Join our Talent Network][2]<http://www.everence.com/careers>

Confidentiality Notice: This information is intended only for the
individual or entity named. If you are not the intended recipient,
do
not use or disclose this information. If you received this e-mail
in
error, please delete or otherwise destroy it and contact us at (800)
348-7468 so we can take steps to avoid such transmission errors in
the
future. Thank you.

--
Jerry Draper, Trilobyte Software Systems, since 1976
IBM I, Network, and Connectivity Specialists, LAN/WAN/VPN
Representing WinTronix, Synapse, HiT, and others .....
(415) 457-3431 . [3]www.trilosoft.com

References

Visible links
1. https://josephgfrank.org/
2. http://www.everence.com/careers
3. http://www.trilosoft.com/
--
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.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com