We have a FMS v11 in our main office with a fixed IP. Our remote sales office has its own FMS server v11.

I have a FM script in the sales office. It basically does a very simple find all sales enter today and then update a table in the main office FMS server. This is done using the External Data Source. The script run perfectly from a sales office PC with FM Pro. However, when I run the same script as Server Schedule Script in the sales office, nothing gets update in the main table. No error is reported and the status is OK.

Could it be the scheduled script does not support external data source ? I hope this is not the case.

Could it be the scheduled script does not support external data source?

FMS can only see and work with files it hosts itself.

Vaughan,

FMS cannot see any External Data Sources? I'd need a robot to pull new mySQL records or they'd need to be pushed into FM?

tia,

Barbara

I can't find any documentation that addresses this. Anybody?

I found this in Page 133 in fms11_help.pdf

"A server-side FileMaker script that is running on one FileMaker server cannot open a database that is hosted on a different FileMaker server."

Thanks, Supernatural, but that doesn't really answer my question. Apparently, server doesn't see ESS sources, and I can't find documentation to that effect.