Informix and DAO
Posted in 2003
Does anyone here use DAO when accessing Informix? Our informix box has 1000+ connections to it for only 100+ instances of a legacy program that we have which accesses Informix via DAO. In doing some testing I am finding that DAO is not closing connections to the informix box. For example if I open a database connection I get a connection to informix. Then I open a recordset and get another connection. Then I close the recordset and kill the recordset object. I still have 2 connections to informix. Then I close the DAO database connection and kill the DAO connnection and still I have 2 connections to Informix. Only when the program is terminated do the connections finally get dropped. I tried a similar test using ADO and everything ran perfectly over just 1 connection. Does anybody have/had a similar problem and if so have you found a solution outside of scrapping DAO. (That option is to large in scope to attempt at the moment) Robert Phillips (rphillips@ce-a.com) Systems Analyst Chamberlin Edmonds and Associates (www.ce-a.com) 404-634-5196 x1261