asked on

Getting ERROR: [DataDirect][ODBC SequeLink driver]Out Of Memory when using Filemaker ODBC Connector

I recently installed filemaker 9 advanced server and have setup the ODBC drivers to allow me to use sql to interact with it. The issue however is that II can usually query the table once or twice and then i get an error of ERROR: [DataDirect][ODBC SequeLink driver]Out Of Memory when trying to run it a third time. I am connecting to the database via coldfusion 7 and RazorSQL (a generic query tool) both give me the same results. I even tried creating a new table and copying the data over to it and querying the new table only to have the same thing happen.

I created a ODBC System DSN using DataDirect 32-bit SequeLink 5.5 drivers.

Any help would be appreciated. I've tried calling filemaker but they are telling me they don't support the ODBC connector except the test connection in the system dsn. (WHICH IS CRAZY)

FYI... This is not my choice to use filemaker, it's my clients so please no filemaker bashing... I know already, FM sucks!

ASKER CERTIFIED SOLUTION

_agx_

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

polobruce

ASKER

yea that's what i'm trying now and it seems link i'm getting much better results. Apparently after speaking with a senior developer at Filemaker they advised me that their is a memory leak issue with the datadirect drivers. Which... basically make them useless.

Thanks for your help!