Mohan,
As Miha suggested.
Double check that the OLEDB or the ODBC As/400 drivers support transactions.
Last time I worked with them I don't remember that they did.
Its best to be on Client Access V5R2 or later (with current all PTFs) to be
fully supported from .NET. (I understand that you can remain on OS/400 V4R5,
its the client that needs to be current).
http://www-1.ibm.com/servers/eserver...edb/index.html http://www-912.ibm.com/n_dir/nas4apa...ight=2,ii13341
The above links are from June 3rd, not sure if there are more current
versions with better support...
If you look around the SQL Thing site (
http://www.sqlthing.com) and the
above sites you should come across a number of samples and further
information.
Hope this helps
Jay
"Mohan" <mo************@hotmail.com> wrote in message
news:96**********************************@microsof t.com...
I had tried OLEDB (IBMDA400) with .net for Transactions. Transactions are
not supported at all with OLEDB and AS400. Now I am trying ODBC.NET for
transaction. Rollback does not work with ODBC.NET
Can anybody help? If Transactions are not supported also in ODBC.NET , how
to lock records and execute statements as a whole work? Any ideas?
Please help as I had spent lot of time on this