471,853 Members | 858 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,853 software developers and data experts.

AS400 Rollback does not work !

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.NE

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
Nov 20 '05 #1
3 2940
Does as400 driver support transactions?

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"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

Nov 20 '05 #2
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

Nov 20 '05 #3
In order to use transactions on the AS400, the AS400 files must be set up to
use journaling. Most 400 shops don't do it because of the memory overhead
and disk overhead. It is a hog. However, you can activate it on only the
tables you need to.

Tim

"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

Nov 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by level8 | last post: by
reply views Thread by Kin | last post: by
reply views Thread by alan_sec | last post: by
13 posts views Thread by Sehboo | last post: by
14 posts views Thread by Brad Allison | last post: by
2 posts views Thread by Ian Boyd | last post: by
NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.