Open Hosted File Using ActiveX (VBScript)

[Ted S]

Hi all,

I'm trying to run a script on a remotely hosted file (FMServer 7) by using the FileMaker's ActiveX functionality. I'm launching this from within a VBScript (Script.vbs). I'm open to using either native FileMaker authentication or external authentication.

I can get it to run locally but it can't find the file when its hosted.

Here's the pertinent section:

Set objFMfiles = objFM.Documents.Open("fmnet:/10.20.30.40/FileName.fp7","AccountName","Password")

Any idea where I'm going wrong?

[Reed]

How about using an opener file. Just use the vbscript to open the local opener file, which has a startup script that will open the remote file and close itself.

Dana

[Ted S]

Yup, I could do that. In fact I was doing exactly that on v6 but the ActiveX route seems cleaner.

There is a note in the help section about not being able to OPEN remotely hosted files using ActiveX but strictly speaking, these files are already open.

[NYPoke]

I am just getting into v7, but I think this is a general situation, not just v7.

Your Document Open is probably trying to open the file using the File Sharing on the Network. In the process, it is attempting bypass the FileMaker Server.

If you are running the FM Server, I would suspect this to be the case. The Opener Script would be the answer.