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

[Chris C. <cc...@fi...>]

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