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(OdbcHa ndle
hrHandle, RetCode retcode)
en
System.Data.Odbc.OdbcConnection.Open_EnlistTransac tion(Transaction
transaction)
en
System.Data.Odbc.OdbcConnectionOpen.EnlistTransact ion(Transaction
transaction)
en
System.Data.Odbc.OdbcConnection.EnlistTransaction( Transaction
transaction)
en System.Data.Odbc.OdbcConnection.Open()
en
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.GetNewOpenConnection()
en
Microsoft.Practices.EnterpriseLibrary.Data.Transac tionScopeConnections.GetConnection(Database
db)
en
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.GetOpenConnection(Boolean
disposeInnerConnection)
en
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.GetOpenConnection()
en
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.ExecuteNonQuery(DbCommand
command)
en
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.ExecuteNonQuery(CommandType
commandType, String commandText)
en DataAppBlock.Form1.button7_Click(Object sender, EventArgs e)
en C:\Proyectos\DotNet\SandBox\DataAppBlock\DataAppBl ock
\Form1.cs:línea 193
en System.Windows.Forms.Control.OnClick(EventArgs e)

Aby idea why o what i miss ???

Thanks

Enrique