Does your table have a date / time field by chance?
You should report this issue through your support channel or the bug reporting forum:
If you can, please include the definition of the SQL table (with all data types), and the exact version of the ODBC driver (in the "Drivers" tab of the ODBC Administrator).
Actual Technologies - ODBC for Mac OS X
We have a windows environment. The change was the MS SQL version from 2000 to 2008 and the Windows ODBC Driver to SQL Server Native Client 10.0 Version 2007.100.1600.22.
We are running FileMaker Pro 11 Version 11.0v3 client and FileMaker Server Advanced Version 22.214.171.124.
Have you updated your ODBC drivers on the server or workstation? Can you connect with the test button within the ODBC setup control panel?
Lee Snover's advice is the first thing you should try. Then if it still isn't working, see if something else using an ODBC connection works such as Excel. If it sees the data, then the problem is with FileMaker. If Excel doesn't see the data either, then it is probably an ODBC driver problem. If so, download the latest drivers and reinstall them. If it is a FileMaker problem, reinstall FileMaker server. Any chance you're going to upgrade to 12 soon?
We found out what is wrong. There was a field in SQL with more than 4000 characters. We reduced the field size to under 4000 and it worked.