[mdb-dev] PHP and ODBC leaving lots of files open

[Mike P. <mj...@fi...>]

Hi guys,

Bit of a stab in the dark, but I thought I'd ask the list if anyone has 
seen anything like this - Google hasn't helped me thus far.

We've got a bunch of PHP scripts using mbdtools via odbc.  I've just 
noticed that if I use 'lsof -ap' on one of the httpd processes running 
the scripts, I discover that none of my 'odbc_close()' calls appear to 
have closed the .mdb file that I assume 'odbc_open()' has opened.

This has become a problem because with more people using the scripts, 
the open files build up and up until the process breaks because it has 
too many open files.

Surely if I use odbc_close() it should be closing the .mdb file it has 
opened, no ?  Or have I missed something blindingly obvious ?

Thanks, as always, for any hints/help...

-- 

Cheers,

Mike

mj...@fi...                                 http://www.filmsat59.com
Films at 59 Ltd, 59 Cotham Hill, Bristol. BS6 6JR ENGLAND +44 117 906 4300