PHP and ODBC leaving lots of files open

Mike Prudence <[email protected]> Mon, 21 Jan 2013 18:26:18 +0000
Newsgroups gmane.comp.db.mdb-tools.devel
Message-ID <[email protected]>
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

[email protected]                                 http://www.filmsat59.com
Films at 59 Ltd, 59 Cotham Hill, Bristol. BS6 6JR ENGLAND +44 117 906 4300

------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122412