.NET TransactionScope -> ERROR [HY000] [Informix][Informix ODBC Driver]General error
Posted in 2007
Hi using Microsoft Enterprise Library Data access App Block i have this code using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { Database db1 = new GenericDatabase( ConnStringBuilder.ConnString, OdbcFactory.Instance); String sql1 = "insert into test_text values (51, 'holas1')"; db1.ExecuteNonQuery(CommandType.Text, sql1); scope.Complete(); } The ExecuteNonQuery causes this exception: No se controló System.Data.Odbc.OdbcException Message="ERROR [HY000] [Informix][Informix ODBC Driver]General error." Source="iclit09b.dll" ErrorCode=-2146232009 StackTrace: en System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) en System.Data.Odbc.OdbcConnection.Open_EnlistTransaction(Transaction transaction) en System.Data.Odbc.OdbcConnectionOpen.EnlistTransaction(Transaction transaction) en System.Data.Odbc.OdbcConnection.EnlistTransaction(Transaction transaction) en System.Data.Odbc.OdbcConnection.Open() en Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection() en Microsoft.Practices.EnterpriseLibrary.Data.TransactionScopeConnections.GetConnection(Database db) en Microsoft.Practices.EnterpriseLibrary.Data.Database.GetOpenConnection(Boolean disposeInnerConnection) en Microsoft.Practices.EnterpriseLibrary.Data.Database.GetOpenConnection() en Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command) en Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(CommandType commandType, String commandText) en DataAppBlock.Form1.button7_Click(Object sender, EventArgs e) en C:\\Proyectos\\DotNet\\SandBox\\DataAppBlock\\DataAppBlock \\Form1.cs:línea 193 en System.Windows.Forms.Control.OnClick(EventArgs e) Aby idea why o what i miss ??? Thanks Enrique