AnsweredAssumed Answered

FileMaker ODBC driver memory leak

Question asked by grzesgbc on Oct 5, 2012
Latest reply on Apr 3, 2013 by EdQuigley

Summary

FileMaker ODBC driver memory leak

Product

FileMaker Server

Version

11.0.3.309

Operating system version

Windows Server 2008 R2 Standard Service Pack 1

Description of the issue

Using ODBC to import data from a hosted FileMaker database to an Excel spreadsheet causes a memory leak. Each time a connection i created from excel 49 handles are used. When the connection is terminated only 9 handles are released. Each time the data table imported to excel is refreshed another 40 handles are used and not released.

Steps to reproduce the problem

1. Create a new data source DSN using FileMaker ODBC driver on a client computer. The new data source should point to a hosted FileMaker databsse (i.e. sample database).
2. Create a new Excel spreadsheet and use DSN to connect to the hosted FileMaker database and import data.
3. Refresh the data table in Excel and check how the number of handles used increased. The number of handles used by Excel can be observed in Windows Task Manager.

Expected result

Each time the data table imported to excel is refreshed the same number of handles should be used and released. The number of used handles should not increase.

Actual result

Each time the data table imported to excel is refreshed another 40 handles are used and not released. After 10 times the number of used and not released handles increases by 400.

Configuration information

FileMaker ODBC driver version 11.3.81
The issue did not exist in FileMaker 10.
The issue can be reproduced in FileMaker 11 and 12.

Outcomes