Re: Writing a PC program with SQL connectivity

More specifically you need the
"ACS Windows App Pkg English"

That has the windows specific stuff like ODBC, OLEDB, and .NET drivers.

It also has some windows help files,
- OLE DB Provider Technical Reference
- Programmer's Toolkit
- .NET Provider Technical Reference

If you've already installed the Windows App Package,
You should see links to the help files under the "IBM i Access Client
Solutions" folder on your start menu.

Charles



On Wed, Mar 27, 2024 at 2:57 PM Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

You won't be able to use IBM.Data.DB2.dll without a $$$$ License for Db2
Connect..

Use the free drivers that come with ACS.

Charles

On Wed, Mar 27, 2024 at 12:45 PM <smith5646midrange@xxxxxxxxx> wrote:

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?

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