Moved from FM10 WinServer 2003 to FM11 WinServer2008/64

[ibcarolek]

First, let me say YES! we are set up with the 32 bit drivers. That aside,

Our FM app works great as a stand alone app from a Win2003 box with ESS to SQL2008. But when we moved it to be hosted on our FM11ServerAdv, the application can import records from SQL2008 but its ESS connections fail upon managing the external database.

While we had both the 64bit and 32bit ODBC set up with the same name, the issue did not resolve upon deleting the 64bit odbc dsn. Not even after a reboot.

Any tips on how else to troubleshoot?

[ibcarolek]

To clarify, if the file is not hosted, the ESS works great. Even on the Windows2008/64box. However, once the database is uploaded onto FM11Adv on that same box, ESS fails. We have run repair on FM11Adv, rebooted yet again, and still ESS connections fail.

[ibcarolek]

Oh, my! We found the issue. The external data source was tagged to show Views, but not Tables. Apparently, when the file is not hosted, it does not need to have Tables checked. But when it is hosted, Ess needs both Tables and Views to be able to see the views. Pfew! This looked like a show stopper! But...the show must go on, and it will :laugh2: