473,223 Members | 1,792 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,223 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 3069
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: level8 | last post by:
Hi, Everybody, I'm a Hungarian SQL user and I need a little help for SQL Server 7 ! I protect my table against bad data with a trigger. I use ROLLBACK and RAISERROR statement in this trigger....
0
by: Kin | last post by:
Dear all, Thank you very much for your help in advance. I am using DB2 on AS400. Recently, I receive deadlock message from developers. I would like to do following tasks. Could anyone teach me...
2
by: Amanda | last post by:
From a guy in Microsoft newsgroups: | In *comp.databases.ibm-db2* there are always IBM guys | from the Toronto labs on line.Post with the | -for the love of god please help- | line...
0
by: alan_sec | last post by:
Hi. Does the com.ibm.as400.access.AS400JDBCDriver driver that is part of JTOpen (http://jt400.sourceforge.net) works with db2 udb version 7 that is installed on windows 2000? I' m trying to...
13
by: Sehboo | last post by:
Hello, we have data sitting on AS400 (V4R5M0) - DB2-400. I need to access that from my vb.net application. I don't know anything about AS400. Is it possible to get data from tables and stored...
14
by: Brad Allison | last post by:
Sorry to repeat myself if this is the same question I asked in the past, but I have finally made a connection to our AS400 through ODBC. I tried to get the connection using the data connection...
5
by: Amaryllis | last post by:
I'm trying to call a CL which is located on our AS400 from a Windows application. I've tried to code it in different ways, but I seem to get the same error every time. Does anyone have any clue...
0
by: sunrt | last post by:
We have an As400 system that has program which executes batch files which resides on the SQL server 7.0 computer . Those batch files run SQL server jobs using isql. The whole idea about this is...
2
by: Ian Boyd | last post by:
We're encountering a situation where we're encountering a deadlock, and someone's been made the deadlock victim. But after that, DB2 refuses to run any SQL, and instead we get the error message: ...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.