Cannot see ODBC Data Sources on local MS SQL database
I am using FileMaker Pro Advanced v11.01 on the Windows platform. Though I have been using FileMaker for over a decade, it is only in the past several months that I have been using it with MS SQL data sources. I am having trouble creating an External Data Source, but only when the SQL database is being hosted on the local machine. Here are the specifics:
When the SQL database is hosted over the network and I am running FileMaker Pro Advanced 11 in Windows XP, I can create External Data Sources in FileMaker without a problem. Everything works as expected. When I move the same MS SQL database to my local machine (Windows 7, 64 bit) and host it there, the ODBC data sources do not show up in FileMaker's Select ODBC Data Sources dialog. I can, however, use the DSNs that I have set up on this same machine to access the same database via Excel/MS Query, so it appears as if the DSNs are available.
I have tried using three different drivers (SQL Server, SQL Native Client, and SQL Native Client 10.0), I have set up both User DSNs and System DSNs, and I have pointed the DSN to the named database server as well as the (local) database server. None of this seems to make a difference. The only thing that I can think of is that I have a MS SQL hosting preference that is incorrect, or that FileMaker is not compatibel with Windows 7, 64 Bit.
Any of you SQL gurus have any ideas about what I need to do to fix this one?