> mike <mikeadenergy.com.au> wrote:
> > I am having problems trying to run a SQL query on a large FM Pro 5.5
> > file (running on a Mac under OS X) from an ASP page and an ODBC driver
> > (which I set using a System DSN on my W2K server, using the filemaker
> > pro ODBC driver). If I query small files it is fine and comes back
> > with results etc (albeit almost 50 times slower than SQL Server
> > 2000!). However, if I query a large file it brings FM Pro to it's
> > knees and it then stops responding forcing a quit and restart. In fact
> > I have just bought our production FM Pro server to it's knees by doing
> > a simple SELECT query... not great when it's our busiest day of the
> > week!
> Although FMI will not admit this, Filemaker does not do well serving as
> an ODBC data source. A fellow developer tried to do what you're
> attempting, and after a long tale of frustration, finally got an
> engineer at FMI to admit that the ODBC capability was meant to pull
> single records, such as for a customer query, or at most a few records
> at a time. As you phrase it, small files are fine. Asking for large
> chunks of data is either glacially and unuseably slow, or causes total
> So here's an alternative to simply using FM as an ODBC data source.
> Start your search at
> and take a look at their plugins. (I'm not sure the SQL one is meant to
> provide 2-way connectivity, it might be simply from SQL > FM)
> Also look at
> particularly their FMtor product.
> While you're at the first link, take a look at Servoy. It may be more
> backend. Look ma! Filemaker looks with an SQL heart!
> Don't tear out any more hair trying to get FM to do something it wasn't
> meant to do.