Hi,

I'm having some problems with transactions.

I have this process where I manually start a transaction using a query "BEGIN WORK", then do some work, then in case of errors I will NOT do "COMMIT WORK" or "ROLLBACK WORK" and I'll let informix do that (it will automatically roll back).

Problem is that even if I've set TxOptions.DisconnectAction=xdRollback, at the third "BEGIN WORK" I get a "GENERAL ERROR" error.

Why is that? I tried to manually do a "ROLLBACK WORK" at the end of the process and I am not receiving the error anymore so it looks like transactions are not rolled back automatically.

Since this was working when i used sqldirect, is it a bug or do i have to change the way I'm using transactions?

thanks!
Lorenzo

Hello Lorenzo

AnyDAC for native drivers implements synchronization of TADTransaction state and transaction control commands execution. For bridge drivers this is not implemented, because requires DBMS syntax knowledges, etc. It is not a bug, but a limitation of AnyDAC bridge drivers.

The right solution will be - do not execute transaction control commands, but use TADConnection.StartTransaction / Commit / Rollback methods.

Hi,

thanks for answering. Ok I'll try to modify that.

Meanwhile, what about enabling direct access for informix and as400? is there any hipotesys and when?

I could give you access to as400 using teamviewer but I don't know how long it will take you.

thanks.
Lorenzo

1) We are considering to implement AnyDAC native driver for Informix. May be later this year.
2) We have may be 1-2 customers who are using AS400. Also, without direct access to AS400 system, will be really hard to implement the driver. So, because there is not much AS400 support requests and we does not have AS400 system access, we have no plans to implement native AS400 driver.