Is this FileMaker Server or Filemaker Server Advanced? As I understand it, you need server advanced for ODBC.
I am using FileMaker Server and not the advanced one.
But I am using ESS (External SQL Data Sources) for connecting with MS SQL which is available on all FileMaker versions starting with 9.
I have also tried FMPS 11 with FMP 11 client and still have the same problem.
FMPS 9 is running on Windows 2003 SP2 server.
FMP 9 is running on Windows XP, and SQL 2008R2 is running on Windows Server 2008.