We've got two FileMaker 11 servers setup, balancing about 100 files each. On the second server (server b) I have cwp/php enabled and have a number of files which can be access using API for PHP. I've recently had to link (relate) to a file which is on Server a from one of my files thats on server b. I have a layout in my file which accesses all the fields I want displaying from the related file.
Does the account have access rights to the file on server a? Is the extended privilege to fmPHP checked?
It's been a few years since I had to deal with the multiple server issue that you described. At the time, I was trying to setup a single database that I could use with the API, which would act as a gateway to the databases that I needed database from.
If I remember correctly, the problem was that the credentials being used by the API to access Server A either weren't being passed through to Server B, or simply weren't honored by Server B. Also, it didn't matter that the account being used to access the database on Server A had an identical account (with the exact same account name and password) in the database on Server B.
Unfortunately, I never did resolve this. I'm interested in hearing if anyone else has found a solution.
Thanks for replying to this. I was exploring the forums last night and came across ths thread which sounds like they were trying to do the same thing.
I'll experiment, but lack of time on the project probably means I'll end up going the import route - really trying to normalise my data and not have multiplr instances of it.