IBM.Data.DB2 Connection string

[Josh]

Hello All,

We have an issue with the IBM DB2 Managed Data Provider (IBM.Data..DB2). We
manged to establish the connection and fetch data using Select queries.
However we are uable to save any changes to the database as Update, Delete
and Insert commands fail with a message "inconsistent data". The same SQL
works through the oledb provider. When had the same issue using the oledb
data provider we had it sorted out by setting the TxnIsolation to 32 in the
connection string. However we couldnt find any means to set the Transaction
Isolation to 32 for the IBM DB2 managed Data provider.

We found that the Isolation level 32 is highly specific to DB2 on AS/400 but
could not find a way to set the same in a .NET CRUD application that uses
IBM.Data..DB2 as the Data Provider.

There is very little documentation availabe on connection strings for the
IBM DB2 managed Data provider. That leaves us with little or no choice than
to depend on industry gurus like you. We would be grateful if you could tell
us how to set the Transaction Isolation or atlest provide a link that could
give us more info on the connection string settings for the IBM DB2 managed
Data provider.

Regards
Josh & Team

 

[Carlos J. Quintero]

I have no idea about IBM DB2 but there is a newsgroup
"ibm.software.db2.udb.beta" in the server "news.software.ibm.com" where you
should have more chances of help about this provider, including from IBM
people.

HTH,

Carlos Quintero

 

[William Ryan]

This might help you...
http://www7b.software.ibm.com/dmdd/library/techarticle/0304alazzawe1/0304alazzawe1.html

If fyou want to connect through ODBC, this should help...
OdbcConnection conn = new OdbcConnection(
"DSN=db2sample;uid=db2admin;pwd=db2admin");


HTH,

Bill