Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is it true that the Access ODBC driver creates a memory leak?

April 26, 2017creates driver leak memory ODBC

0

Posted

Is it true that the Access ODBC driver creates a memory leak?

1 Answer

0

Posted

Apparently so. There is an article on the MS KB – MS have confirmed the leak in the MS Access ODBC driver, and even provide some sample code to show it off. The leak occurs when a connection is made, so if you’ve got an xSAPI app (CF, iHTML, ASP, etc.) that uses ODBC to MS Access then it will gradually consume memory after each connection until the system dies. If you use something like CGI where the process doesn’t run within WebSite then memory appears to get cleared up OK, but I can’t confirm it as my ASP pages us the OLE DB provider for Access (guess what, no visible leaks! – my ASP site’s been up for ages).