Informix + Ole Db extrange problem

Posted in 2004

Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Platform-Specific Issues, Versions, Editions & End-of-Life

Jesus Antonio Santos Giraldo — Thu, 22 Jan 2004 23:19:52 — source: IIUG Forums & Mailing Lists

Hi All, A contractor of our company has been receiving the following error message while trying to insert data(150 bytes) into a byte column of an informix table: E_OUTOFMEMORY(0x8007000E) He is using Visual Studio .NET (2003) and C# and Ole.DB. Informix database is IDS 9.3 9.30.HC2W8 running on HP-UX 11.0. The clients used were: Windows 2000(SP6) with .Net framework installed, Client connect2.80tc1 Windows XP(SP1) with .Net framework installed, Client connect2.80tc1 The confusing part is that when he try to insert a null into the byte column it works and no error message is returned, but when he try to insert one-byte or two-byte... or 150-byte, etc; he get the E_OUTOFMEMORY error. Previosuly he inserted data in the same table with ODBC with no problem but now that he is using Ole.Db the inserts to byte columns are not working properly. Other problem is that no much information is given when the insert fails in the exception mechanism of C#... Attached is an extract of the code : problemcod.cs And the esxception trace : trace.txt Is there any configuration related to Ole.DB in the server that I must take care of? Any help would be very appreciated. -- Atte, Jesus Antonio Santos Giraldo ----------------------------------- jeansagi@myrealbox.com jeansagi@netscape.net Imposible transferir los datos hacia la tabla destino, Error: La información del error no está disponible: E_OUTOFMEMORY(0x8007000E). -- -- at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbP arams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at COSTOSABC.EjecutaTransferencia.CargarObjetoBlobServer() in c:\\\\costosabc\\\\costosabc\\\\ejecutatransferencia.cs:line 1701System.Data.OleDb.OleDbException: La información del error no está disponible: E_OUTOFMEMORY(0x8007000E). at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbP arams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at COSTOSABC.EjecutaTransferencia.CargarObjetoBlobServer() in c:\\\\costosabc\\\\costosabc\\\\ejecutatransferencia.cs:line 1701

↪ replying to Jesus Antonio Santos Giraldo

Sathyanesh Krishnan — Thu, 22 Jan 2004 23:50:45 — source: IIUG Forums & Mailing Lists

--0__=08BBE4B0DF1115208f9e8a93df938690918c08BBE4B0DF111520 Content-type: multipart/alternative; Boundary="1__=08BBE4B0DF1115208f9e8a93df938690918c08BBE4B0DF111520" --1__=08BBE4B0DF1115208f9e8a93df938690918c08BBE4B0DF111520 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable Hi Jesus Anton, I am from the IBM Informix OLEDB Provider development team. Thanks very much for bringing this into our attention. I will take appropriate step to rectify this problem. Can you please help us by giving a simplified form of the application t= hat reproduces the problem. (Zip of the .Net C# application and the SQL script to create table sche= ma at the database side.) Even though you have mentioned that you have attach a .cs and .txt file= , it is not actually in the original mail. It will be a great help if you can pass pass the repro to us. Thanks, Satyan. |---------+----------------------------> | | "Jesus Anton...."| | | <jeansagi@myrealb| | | ox.com> | | | Sent by: | | | forum.subscriber@| | | iiug.org | | | | | | | | | 01/22/2004 05:19 | | | PM | |---------+----------------------------> >--------------------------------------------------------------------= ----------------------------------------------------------| | = | | To: ids@iiug.org = | | cc: = | | Subject: Informix + Ole Db extrange problem [2476] = | >--------------------------------------------------------------------= ----------------------------------------------------------| Hi All, A contractor of our company has been receiving the following error message while trying to insert data(150 bytes) into a byte column of an= informix table: E_OUTOFMEMORY(0x8007000E) He is using Visual Studio .NET (2003) and C# and Ole.DB. Informix database is IDS 9.3 9.30.HC2W8 running on HP-UX 11.0. The clients used were: Windows 2000(SP6) with .Net framework installed, Client connect2.80tc1 Windows XP(SP1) with .Net framework installed, Client connect2.80tc1 The confusing part is that when he try to insert a null into the byte column it works and no error message is returned, but when he try to insert one-byte or two-byte... or 150-byte, etc; he get the E_OUTOFMEMORY error. Previosuly he inserted data in the same table with ODBC with no problem= but now that he is using Ole.Db the inserts to byte columns are not working properly. Other problem is that no much information is given when the insert fail= s in the exception mechanism of C#... Attached is an extract of the code : problemcod.cs And the esxception trace : trace.txt Is there any configuration related to Ole.DB in the server that I must take care of? Any help would be very appreciated. -- Atte, Jesus Antonio Santos Giraldo ----------------------------------- jeansagi@myrealbox.com jeansagi@netscape.net Imposible transferir los datos hacia la tabla destino, Error: La informaci=F3n del error no est=E1 disponible: E_OUTOFMEMORY(0x800700= 0E). -- -- at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32= hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tag= DBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehav= ior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at COSTOSABC.EjecutaTransferencia.CargarObjetoBlobServer() in c:\\\\costosabc\\\\costosabc\\\\ejecutatransferencia.cs:line 1701System.Data.OleDb.OleDbException: La informaci=F3n del error no = est=E1 disponible: E_OUTOFMEMORY(0x8007000E). at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(In= t32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tag= DBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehav= ior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at COSTOSABC.EjecutaTransferencia.CargarObjetoBlobServer() in c:\\\\costosabc\\\\costosabc\\\\ejecutatransferencia.cs:line 1701 = --1__=08BBE4B0DF1115208f9e8a93df938690918c08BBE4B0DF111520 Content-type: text/html; charset=ISO-8859-1 Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> Hi Jesus Anton,</= font> I am from the IBM Informix OL= EDB Provider development team. Thanks very much for bringing= this into our attention. I will take appropriate step = to rectify this problem. Can you please help us by giv= ing a simplified form of the application that reproduces the problem. <= /font> (Zip of the .Net C# applicati= on and the SQL script to create table schema at the database side.) </f= ont> Even though you have mentione= d that you have attach a .cs and .txt file, it is not actually in the o= riginal mail. It will be a great help if yo= u can pass pass the repro to us. Thanks, Satyan. <img src=3D"cid:10__=3D08BBE4B0DF1115208f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "Jesus Anton..= .." <jeansagi@myrealbox.com>">"Jesus Anton...." &l= t;jeansagi@myrealbox.com> <table V5DOTBL=3Dtrue width=3D"100%" border=3D"0" cellspacing=3D"0" cel= lpadding=3D"0"> <tr valign=3D"top"><td width=3D"1%"><img src=3D"cid:20__=3D08BBE4B0DF11= 15208f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"72" al= t=3D""> </td><td style=3D"background-image:url(cid:30__=3D08BBE4B0DF1115208f9e8= a93df938@us.ibm.com); background-repeat: no-repeat; " width=3D"1%"><img= src=3D"cid:20__=3D08BBE4B0DF1115208f9e8a93df938@us.ibm.com" border=3D"= 0" height=3D"1" width=3D"225" alt=3D""> <ul> <ul> <ul> <ul>

Related threads

Glossary

IDS (Informix Dynamic Server)