Re: Writing a PC program with SQL connectivity

See:

IBM i Access Client Solutions - Windows Application Package for Windows.

 Readme

- Connectivity to Db2® for i using ODBC, .Net, OLE DB and XDA
- Programming Toolkit for accessing IBM i system objects
- Support for TLS/SSL connections


On Wednesday, March 27, 2024 at 05:02:28 PM EDT, smith5646midrange@xxxxxxxxx <smith5646midrange@xxxxxxxxx> wrote:

Use the free drivers that come with ACS.

Can you provide a little more info like the file names or something?  I am completely lost so "free drivers" did not help.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Charles Wilt
Sent: Wednesday, March 27, 2024 4:57 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Writing a PC program with SQL connectivity

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.

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