Re: Writing a PC program with SQL connectivity

I'm not sure how robust this application is that you need but I have used
Richard Schoen's port of JT400.jar to DLL to make connections. Makes it
pretty easy without setting up an ODBC. There are some limitations around
SSL or SSH or something along those lines (I don't remember the
specifics).

https://www.nuget.org/packages/JT400.78

Also here are a couple of articles as well.
https://www.ibmimonitoring.it/IBMiMonitoring_HowToAs400_JTOpen_dotNet_EN.asp
https://www.ibmimonitoring.it/IBMiMonitoring_HowToAs400_JTOpen_dotNet_connessioneJDBC_EN.asp

I'm not sure this is the right list for this. If not, let me know which

one
is and I will repost it.

I have been asked to write a PC .exe program that will execute an SQL
statement on the IBM i and then exit with an appropriate return code based
on what it found. I know how to do all of this in C#.NET except I can't
seem to find what I need for the SQL connection piece.

I assumed that I needed a .dll installed and added into my program like I
need to do for MySQL connections. I found info saying that I needed
IBM.Data.DB2.dll. I googled it to search for a download site and found

https://www.ibm.com/support/pages/download-initial-version-115-clients-and-d
rivers. I downloaded IBM Data Server Driver Package (DS Driver).
However,
it looks like it is going to install DB2 on my laptop not just the .dll
that
I was looking for.

Can someone help point me in the right direction for this?