I'm very new with DB2 but have started a project that require to manipulate DB2 Database in AS400 v7r1 iSeries.
I'm try using IBM.Data.DB2.iSeries nuget to make a connection but no luck. My connection string in Web.config like
<add key="ConnectionString" value="Provider=IBMDA400;Password=pwd;User ID=user;Data Source=server_ip_add;Transport Product=Client Access;SSL=DEFAULT;Default Collection=default_schema"/>
var myConnection = new iDB2Connection(connectionString);
The returned error is 'The connectionstring property is invalid'
There are some other nugets named IBM.Data.Db2 and IBM.Data.Db.Provider but I havent tried it. These seem works with .NET 4.0 but I'm not sure they can work with AS400 v7r1.
Could you please give me some guides?