RE: Writing a PC program with SQL connectivity

Thanks Bryan. That kind of helped. I found IBM.Data.DB2.iSeries.dll. It
appears to have IBM.Data.DB2 inside of it.

Every sample program that I can find references DB2Connection. It appears
that IBM.Data.DB2 has iDB2Connection not DB2Connection.

I have tried to use it but I get an error that my connection string is
invalid. Here is my connection string.

string myConnString = "Server=192.168.1.91; Database=MIDOHIO;
UID=JSMITH; PWD=myPassword;";

If I do STRSQL it responds "Current connection is to relational database
MIDOHIO." so I am assuming that MIDOHIO is the "Database" in the string.

Do you see what is wrong with this?



-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Bryan
Dietz
Sent: Wednesday, March 27, 2024 3:54 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: Writing a PC program with SQL connectivity

do you have the windows portion of ACS installed?
That is where those DLL's exist.

or you could use jt400.jar for ODBC sonnection I see this is the one to
download from ACS download page:
IBMiAccess_v1r1_WindowsAP_English.zip

Bryan


smith5646midrange@xxxxxxxxx wrote on 3/27/2024 1:45 PM:

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?