Re: Writing a PC program with SQL connectivity

To Smith5646, stop looking for DLLs, that's too deep in the weeds - all that will be installed when you get the Application Package component of Access Client Solutions. IBM Db2Connection might work, but you don't have to pay for that. IBM's Db2 stuff is not always universal across all IBM systems.


Did you ever use ODBC with the old Access client for iSeries? This should be like that.


Best wishes!Vern


On Wed, 27 Mar, 2024 at 4:19 PM, Marc Rauzier <marc.rauzier@xxxxxxxxx> wrote:


To: midrange-l@xxxxxxxxxxxxxxxxxx

Le 27/03/2024 à 21:52, smith5646midrange@xxxxxxxxx<mailto:smith5646midrange@xxxxxxxxx> a écrit :

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<http://192.168.1>.91; Database=MIDOHIO;
UID=JSMITH; PWD=myPassword;";

You may want to review this old redbook
https://www.redbooks.ibm.com/redbooks/pdfs/sg246440.pdf

Chapter "4.5.2 iDB2Connection and ConnectionString properties" provides
some details.

Link found in
https://www.ibm.com/support/pages/ibm-i-access-windows-net-data-provider
page.

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?