Transactions with OLEDB .Net ?

Posted in 2003

Filip Kierzek — Tue, 29 Jul 2003 19:32:32 +0200 — source: Usenet: comp.databases.informix

Hello, I am trying to get transactions working under Informix OLEDB provider for Informix using ADO.Net && Visual Studio 2002. Running these two line of code: oleDbConnection1.Open(); OleDbTransaction oTransaction = oleDbConnection1.BeginTransaction(); gets me following error: An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: The ITransactonLocal interface is not supported by the 'Ifxoledbc.2' provider. Local transactions are unavailable with the current provider. Is there any other way of getting transactions to work from ADO.Net in Infomrmix. Thanks in advance for any helpful hints! Filip Kierzek Filip.Kierzek@NoSpam.mobileworks.pl