Re: Writing a PC program with SQL connectivity

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.