create table 'informix'.corporatemenuelements (
menuid NVARCHAR(128) not null,
caption NVARCHAR(255),
type NCHAR(1),
address NCHAR(2048)
)
extent size 32 next size 32
lock mode row;
alter table 'informix'.corporatemenuelements add constraint primary
key
(menuid)
constraint pk_corporatemen269;
from .net with odbc data provider i try:
String sql = "INSERT INTO CorporateMenuElements (MenuId,
Caption, Type, Address) VALUES (?, ?, ?, ?)";
DbCommand cmd = DB.GetSqlStringCommand(sql);
DB.AddInParameter(cmd, "MenuId", DbType.String, menuId);
DB.AddInParameter(cmd, "Caption", DbType.String, caption);
DB.AddInParameter(cmd, "Type", DbType.String, type);
DB.AddInParameter(cmd, "Address", DbType.String, address);
Int32 mustBeOne = DB.ExecuteNonQuery(cmd);
I get:
System.Data.Odbc.OdbcException was unhandled
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
ConMega.CorporateMenus.Persistence.ODBCCorporateMenusPersistence.CreateMenuElement
(String menuId, String caption, String type, String address) en C:
\Proyectos\DotNet\TFS\EquipoC\CorporateLibs\ConMega.CorporateMenus
\ConMega.CorporateMenus\Persistence
\ODBCCorporateMenusPersistence.cs:línea 168
...
How can i get more info on what the hell is wrong...
Whats i the version of your Informix Client SDK 2.90 , 3.10 , 3.50 ?