Oninit cdi / Archive
Talk to an expert →

ERROR [HY000] [Informix][Informix ODBC Driver]General error

Posted in 2009

Topics: Storage & Space Management, Connectivity: ODBC / JDBC / .NET, Data Types & Schema Design

eferreyra — — source: Usenet: comp.databases.informix

I have this tables: 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...

↪ replying to eferreyra
LIGHT SCANS — — source: Usenet: comp.databases.informix

Unfortunately I don't have a lot of detailed experience here. But in general, try to narrow it down to the SQL, ODBC, .NET, etc. On the SQL front, try to see if other SQL's work like "SELECT * FROM corporatemenuelements" and "SELECT * FROM CorporateMenuElements". On the ODBC front, I see that it is complaining about the driver. Maybe its setup needs fixing or try another driver. .Net settings may need some attention. If none of this helps, do a Google search on some of your errors. And, last but not least, call IBM support.