Re: PHP and ODBC leaving lots of files open

On 21/01/13 01:26 PM, Mike Prudence wrote:
 > 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.
 >
 > Surely if I use odbc_close() it should be closing the .mdb file it has
 > opened, no ?  Or have I missed something blindingly obvious ?

I would guess you still have transactions pending, so it's not closing. 
See: http://php.net/manual/en/function.odbc-close.php

"This function will fail if there are open transactions on this 
connection. The connection will remain open in this case."

You could try running odbc_commit before the close...

-- 
Chris Craig
Software Developer
Fibernetics Corp
605 Boxwood Dr
Cambridge ON  N3E 1A5
519-489-6700 x 753

------------------------------------------------------------------------------
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