are you reading the server logs (not just FMS logs)? could it be something with Cross-Domain prevention (through the web servers themselves or PHP)? being same subnet, not likely, but possible?
I have a similar setup with two FileMaker Server machines. It is a limitation of FileMaker Server.
One FileMaker Server cannot see tables on another FileMaker Server.
Just to make sure I am clear with what you are saying:
"One FileMaker Server cannot see tables on another FileMaker Server."
Works for FMP
Doesn't Work with CWP
If so thanks!
i've had the same problem and i've solved it, sharing on 1 of the 2 servers, a new file with new tables with all necessary fields. of course the fields of the new file are calculated form both servers and are related to the original file with ID record. also modified the "new record" script on the original solution to create also to the "new file/newtables" a record with only the same ID information.
Yes, that is correct. A FileMaker Client can see both servers and acts as a bridge between them. Server cannot do that.
1 of 1 people found this helpful
Fivos has one solution, just write to both servers whenever the client creates or updates the data. Works in some situations, but not for all. And it runs the risk of having the data get out of sync.
Since both servers are running CWP, you could use "Insert From URL" to call a PHP script on the other server and pass data that way.
Or setup and use RESTful web services to pass information.
I also have used a MySQL database to act as an intermediary, writing data to MySQL and setting a flag to tell a scheduled script on the other FileMaker Server to read the MySQL data and do something with it.