ODBC SequeLink Quirks

[simonen]

Can someone tell me what problems there are using FileMaker 9 Adv Server as a data source through ODBC.

The I ask this is because the software that I am using to use FileMaker as a data source seems to be having issues. One problem is that the Sequelink gives an out of memory error and sometimes it seems to time out.

For example, I am using an email software package that connects through odbc, and if it queries 3 records from filemaker, it works, but if it queries 20,000 records, it times out.

Another example is that when i create an access database to pull in 130,000 filemaker records through odbc, that gives a sequelink error to. I have tried both sequelink 5.4 and 5.5 drivers, but it always errors out.