ODBC Memory Allocation Error

Hi, we have recently deployed a .NET Service application to a client, which connects to an Informix database at polling intervals of 5 seconds During the course of integration testing the client is consistently getting the following memory allocation error: ERROR [HY001] [Informix][Informix ODBC Driver]Memory allocation failure >From our service, we are making ODBC calls ALWAYS passing in-line SQL statements. The error occurs as little as 1-3hrs after the service has started running. The client has observed this error both an Windows Server 2000 and Server 2003 setup. In either case they are running the ODBC Driver: Informix 3.34 32 BIT ICLIT09B.DLL I have found the following post on the same problem, but it never received any reply. http://groups.google.co.uk/group/comp.databases.informix/browse_frm/thread/4daabe1835263363/48b6b02eecb0cb91?q=memory+allocation+error+odbc+informix&rnum=1&hl=en#48b6b02eecb0cb91 Any help would be greatly appreciated. Thanks Mauro Ciaccio

sounds like you are not closing the connections, that's what I'd check first mauroc@beacon-ct.co.uk wrote: > Hi, > > we have recently deployed a .NET Service application to a client, which > connects to an Informix database at polling intervals of 5 seconds > > During the course of integration testing the client is consistently > getting the following memory allocation error: > > ERROR [HY001] [Informix][Informix ODBC Driver]Memory allocation failure > >>From our service, we are making ODBC calls ALWAYS passing in-line SQL > statements. > > The error occurs as little as 1-3hrs after the service has started > running. The client has observed this error both an Windows Server 2000 > and Server 2003 setup. In either case they are running the ODBC Driver: > > Informix 3.34 32 BIT ICLIT09B.DLL > > I have found the following post on the same problem, but it never > received any reply. > > http://groups.google.co.uk/group/comp.databases.informix/browse_frm/thread/4daabe1835263363/48b6b02eecb0cb91?q=memory+allocation+error+odbc+informix&rnum=1&hl=en#48b6b02eecb0cb91 > > Any help would be greatly appreciated. > > Thanks > > Mauro Ciaccio > -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

Hi, thanks for the rapid reply. As far as closing the connections is concerned, I am declaring them as follows using (OdbcConnection con = new OdbcConnection(ConnectionString)) with the "using" statement which means they will be disposed of when I exit my method. Should I instead be closing and setting to nothing explicitly? Is there any chance that the System.Data.ODBC is not working correctly with the "using" statement. Thanks for your help

Can't comment 'cos I don't use ODBC, but it must be worth a try, you should be able to test this easily by stepping through the code and monitoring the memory usage under onstat -g ses mauroc@beacon-ct.co.uk wrote: > Hi, > > thanks for the rapid reply. As far as closing the connections is > concerned, I am declaring them as follows > using (OdbcConnection con = new OdbcConnection(ConnectionString)) > > with the "using" statement which means they will be disposed of when I > exit my method. Should I instead be closing and setting to nothing > explicitly? Is there any chance that the System.Data.ODBC is not > working correctly with the "using" statement. > > Thanks for your help > -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #