2 Replies Latest reply on Jan 13, 2012 3:11 PM by AmrSaem

    FileMaker Pro Server 9 ODBC Connection Problems with SQL 2008

    AmrSaem

      Title

      FileMaker Pro Server 9 ODBC Connection Problems with SQL 2008

      Your post

      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.