How to Open Variable Remote File Name

[CCBtx]

I am wanting to remotely open (on FMServer 9) a variable file name.

I start with a VB Script opening a shell FM9 database on the local PC.

Since a VB Script can't open a remote file, the VB Script is designed to pass the local shell database file the name of the remote file and the ip address of the remote server.

I then build the name in a variable called $OpenFile. One of my names looks like this:

fmnet:/10.8.30.100/ArtaCustomer

...problem is, I am trying to put $OpenFile in the File Path List under Edit Data Source... and it does not accept it.

Any ideas?

[Søren Dyhr]

Right! ... have you tried this instead:

http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/popup_adp.php?p_faqid=5560&p_created=1130361369

--sd

[IdealData]

I nearly chimed in on this one before, and had forgotten the FMP7: protocol - well remembered Soren.

The only problem I see is that you may try to open a file that does not exist or is closed on the server. This leads me to think that the file names must always be known, and therefore could be held in a database, then the $var approach would work.

Please also note the caveat on the fm help notice:

NOTE: If Internet Explorer is the web browser of choice, the "username:password@ipaddress...." syntax is only supported in Internet Explorer versions 3.0-6.0. Also, please be aware that storing credentials in plain text in URL strings can be a security risk. Example: leaving an alias or shortcut with this can lead to unintentional access to the database if the workstation is not protected.

Edited October 27, 2009 by Guest

[CCBtx]

Excellent. Thanks for that direction.

CCB