Re: Writing a PC program with SQL connectivity

[Bryan Dietz <bdietz400@xxxxxxxxx>]

I wish i could, but its been too long.
you might get some help from the previous replies and the knowledge center:
https://www.ibm.com/docs/en/i/7.5?topic=programming-net-provider

Bryan

smith5646midrange@xxxxxxxxx wrote on 3/27/2024 3:52 PM:
> 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?