We have a VB.NET 2005 app that uses IBM.Data.DB2.iS eries provider to connect to our DB2 server.
The connection string for the DB2 connection is set as -
"Data Source=<server> ;User ID=<UID>;Passwo rd=<pwd>;Connec tionTimeout=120 ;"
And this is how we are updating a table in the DB2 server (using transactions) -
Code:
Dim cnDB2 as new iDB2Connection(<connString>)