Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

1,754 views
Skip to first unread message

eferreyra

unread,
Jun 26, 2009, 2:16:01 PM6/26/09
to
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...

LIGHT SCANS

unread,
Jun 30, 2009, 2:09:22 PM6/30/09
to
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.

Vagner

unread,
Jul 16, 2009, 6:19:45 PM7/16/09
to


Whats i the version of your Informix Client SDK 2.90 , 3.10 , 3.50 ?

0 new messages