SQL Server accessing data in FM 11 db

[TASC]

Hi,

We have a database that's built in FileMaker 11. it is hosted on FileMaker Server 11 Adlvanced. Our client has a software that runs some queries through Sql Server and ODBC on to our database to extract information from our database. The table that he is trying to query has 258 fields of which 93 are indexed. When he tries to connect to this table, it tells him that there are too many fields being indexed.

How do we get around this issue? Is there a best practices for setting up a FileMaker database that will allow easy querying through ODBC/Sql Server? Or is there a different way he could connect to our database rather than ODBC that would solve this issue?