Issues Getting FileMaker to Read MSSQL Records

[Bigun]

This is an odd one.

I've been through walkthroughs on the internet and everything, and I can't seem to get FileMaker to read the records from the MSSQL database I have setup.

I have the System ODBC connection setup. I have the Filemaker database setup to use it as an external data source. Filemaker can even see the tables and Fields of the MSSQL database. But under the "Tables" tab under "Manage Databases", the all the tables in the MSSQL database show "?" as the number of records... but somehow it can read all the fields.

When I attempt to put a field on the layout that reads from one of the MSSQL databases, it shows "", and when I click on the field in browse mode, it pops up a dialog message stating, "This action cannot be performed because the required table is missing.".

What is going on!?! :

Edited March 19, 2009 by Guest

[mr_vodka]

Double check that the layout that you are using is one of the current Table occurrences (TO) from the external table. If by chance you created a layout and then deleted the TO somehow, but then added it again later, it will break as although the TO name could be the same, the layout sees it as a TO that no longer exists.

Go under the layout properties and check, or create a new layout from the TO.

[Bigun]

I'm not sure how I would put the TO into play though. I'm just wanting FileMaker to be a decent frontend to look through and pull SQL data. It's almost like I wouldn't need it. If a FileMaker TO is necessary, is there a way to possibly have the TO mirror the SQL fields and data?

[mr_vodka]

No I am talking about the table occurrence of the MSSQL table you are trying to reference, not that of a FileMaker table. In both cases, the layout has to be based on the table occurrence.

Edited March 20, 2009 by Guest