AnsweredAssumed Answered

FileMaker Pro Server 9 ODBC Connection Problems with SQL 2008

Question asked by AmrSaem on Jan 12, 2012
Latest reply on Jan 13, 2012 by 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.

 

Outcomes