I have tried to change the firewall settings butI can't seem to find a way to access the database while the firewall (Norton AV) is turned on.
Check to make sure that port 5003 is opened for Filemaker. Quoting from FileMaker help:
Mac OS: If you are unable to share files on a local network, verify on the host computer that either the Mac OS Sharing firewall has been turned off, or that you have added an open network port configuration for port 5003 to the system sharing preferences. For more information about the Mac OS Sharing firewall and adding a network port configuration, see Mac OS Help
2. Checking for server.pem in the FilemakerPro11 folder
Have you tried replacing this file with the PEM file copied from the machine that does list the file in the Open Remote dialog? (sometimes it's present but corrupted.)
Is BonJour installed on both machines?
3. Sharing settings should not apply here as Filesharing is not used when you open the file via Open Remote and it is safest NOT to share the folder containing these files as attempting to open the file directy via the shared directory can damage the file if two users attempt this at the same time.
Thanks for the fast response!
Sorry if this is obvious, but where do I go to find out about whether port 5003 is open on the mac? Would this not affect both of the machines that I am trying to open the remote Db on?
I have tried replacing the .pem files from the Windows machine that does list the file in the Open remote but no effect.
Bonjour installed during the FMPro installation process on the machine that does not list the file. It was already installed on the other machine.
I'm not a Mac user so cannot advise. The help entry suggests looking this up in the Mac OS help that comes with your computer. This would, however, affect all machines attempting to access the file. I suggested this as an alternative to disabling the firewall as that's not something you usually want to do due to the increased security risk.
Here's an entry from help titled "Cannot see hosted database". You check it over for any factors you may have missed:If the Open Remote File dialog box does not show a shared database that is being hosted over a network:•••The file must be open on the host computer and sharing must be enabled. See Opening files as the host.•••••
Thanks, I will look into opening port 5003 a bit further but fairly confident that I have checked all of the other points listed. Will check again tomorrow with fresh eyes just in case.
Just to update, I disabled the firewall on both the Mac and Windows machines but can still only see the host and not the files using Open Remote. Only difference between the two Windows machines is that the one that can open the remote file is Windows 7 Professional and the one that cannot open the remote Db is Windows 7 Home Premium. But I not sure that is even relevant.
I don't think it's relevant. I can use my Windows 7 Home Premium lap top to access files via open remote without any trouble.
Is the method used to connect the machines to the database exactly the same? (Are they both connecting via ethernet cable or both connecting via wiFi...)
Yes, exactly the same method. All 3 machines are connected via WiFi to a home network.
Update: I tried connecting the laptop that could not see the remote file directly to the modem and it worked! The question now is what could be causing the wireless to act differently?!
Thanks for all your help and advice!
I'd consult with a network tech on that. My theory behind that suggestion was that a wireless connection might connect via a different router or via a wireless connection to the internet which would then function like attempting access to the database from a remote location rather than the local network. But this is not something on which I am well versed on.
did you ever find out about the wifi and "hosts not showing" issues?
i have a similar problem. I am using an Apple Airport base in one part of the office, and an airport express booster in the other part, and the files do not show up from the express in spite of the correct ip. Settings.
Any information appreciated.