AnsweredAssumed Answered

ODBC driver problems

Question asked by dlabi on May 20, 2014
Latest reply on May 12, 2015 by TSGal

Summary

ODBC driver problems

Product

FileMaker Pro

Version

12

Operating system version

win64, OSX

Description of the issue

We have some problems with Filemaker ODBC driver

1.
It seems that there is a memory leak in the driver.
For example:
SELECT GetAs(Picture_container, 'JPEG') from SomeTable
When returned data are very large (1 MB for example), it crashes in SQLGetData.
The workaround for this bug is increasing buffer size (to 2 MB for example) for the function SQLGetData.


2.
Can't get column attributes SQL_DESC_DISPLAY_SIZE or SQL_DESC_UNSIGNED in SQLColAttribute - it returns error.


We are using these platforms to connect to FM ODBC and both bugs are present:

python 2.7 Win64 + pypyodbc.py (https://code.google.com/p/pypyodbc/)
C++ Win64 + Qt library 5.2
C++ OSX 10.6 x64 + Qt library 5.1


Thank you

AD

Steps to reproduce the problem

Use mentioned API functions

Expected result

no memory leaks

Outcomes