FileMaker Pro Server 9 ODBC Connection Problems with SQL 2008
I currently have the following Setup:
1) MS SQL 7 Backend
2) FilemakerPro Server 9
3) FileMakerPro 9
The database is hosted by FMPS 9 that makes an ODBC connection to MS SQL 7 backend to retrieve records. Access to the database records is done via FMP 9 Clients that connects to FMPS 9.
I recently upgraded to MS SQL 2008R2 for the backend. I am able to successfully establish an ODBC connection to MS SQL 2008R2 from FMPS9. The problem that I am having now is that I am unable to access the databse records via FMP 9. I get the hour glass then a timeout.
The strange things about this situation is that I can establish and ODBC connection to MS SQL 2008R2 directly from FMP 9 but not thru FMPS 9.
Any help will be greatly appreciated.