Opener File won't insert host address

[cmartin]

Hello all-

After upgrading to FM server 5.5 and FM pro 5.5, I had some difficulty creating my opener file. In my script the step:

Open [Mydb.fp5(*)]

would show the asterisk rather than the IP address of my host, regardless of whether or not I checked save relative path. The users that are physically in the same office with me were able to use this to connect to the server.

However, users outside of my office would get an error =100 (file not found).

The only way that I was able to get FM to insert the actual IP address of my server (rather than the asterisk) was to create this script from one of the off-site client computers.

Does anyone know what I was doing wrong? Or why this would occur?

Thanks-

Courtney

[Anatoli]

IMHO -- every opener file *must* have correct IP address of server. That is usually different in internal and external networks.

It is 192.168.1.1 on Intranet and 10.12.55.122 from outside.

[cmartin]

That is not the IP address of my server. But my question is about how to get that number hardcoded in to the script. FileMaker is inserting the asterisk automatically, no matter what I do. Can someone please tell me how to get FM to hardcode?

Thanks for responding though, Anatoli!

[Anatoli]

No known way.

For one of my customers I've setup mininetwork in my home office just to get always IP right. It works all the time.

[djgogi]

This procedure avoid problems when changing IP address of server hosting FM files

1)MacOs X

Open NetInfo Manager (applications-->utilities)

Select "machines"

Click on new and edit name of new folder to for ex. FmServer

double click on property name to edit it to "ip_address" (without quotes)

set the ip_address value to IP number of the host you are using.

Click on new (or select from menu "Directory" New property"

Set the property to "name" and it value to FmServer.

Now edit the FileMaker Hosts file (located in preferences-->Filemaker preferences) and add line

FmServer

(if you don't need any other host you could delete them).

2)MacOS Classic

Create an text file Hosts and drop it into system folder

edit the file Hosts

yourserver.yourdomain.com A <insert here the IP address>

FMServer (or whatever name you would like to use) CNAME yourserver.yourdomain.com

Edit the File Maker Host file as in OS X example

Finally open TCP/IP control pannel

Set user level to advanced or higher

The new button "Specify host file" would appear

Select the hosts file you've created

3)Windows

For windows system the procedure is almost the same:

locate the file hosts (windows/system32/drivers/etc/ on XP for other systems I'm not sure)

add the following line

[insert the real IP address of your host] FmServer

of course the above line should be inserted without brackets

Edit FMHosts.txt as in above

Dj