Applescript Auto-Open Remote?

[Topher]

Does anyone know about an applescript that can automatically open a remote database. It seems like something that should be available instead of having to open FM, go to Open Remote, click on the Host, click on the database, etc.

Anybody up for a challenge? I don't know applescript well enough.

[Matthew Stetson]

I found the easiest way is with getURL:

Tell application "FileMaker Pro"

  activate

  getURL "fmp7://user:pass@serverIP/Database Name"

end tell

The downside of course is the username and password are exposed in plain text. You can get around that with the Keychain, or if you compile the script into a run-only application.