I'm trying to use a php web page to access a fm7 database hosted on FM7 Advanced Server and I'm confused about how everything needs to be set up to allow this.

Here's what I have done so far:

Turned on IWP for the db and specified guest access on port 80.

Placed the db in the fm7sa database folder and opened it using fm7 server admin.

Installed fm7AS on windows xp machine running IIS.

Installed PHP 5 on the server.

Copied fx.php to the default web directory on the server.

All that the php web page is doing is connecting to the db and creating a new record, but when I open the page, I get a 802 can't open file error.

The file is already open though.

The FX.php in 8 Hours book covers FMS7A install and config on IIS. The writing in my version has poor editing, but I was able to figure it out. I understand there is a new version, maybe FMWebSchool will offer an upgrade price for it

I had all kinds of weird errors with PHP 5.0.0. I rolled back to v4.3.9 and everything worked well.

In FM, try adding user "fmsadmin" with full access in File->Define->Accounts & Priviledges under the Accounts tab. FMS7A will use this account to access the FP7 file. Close the file in FM7 when opening it in FMS7A.

Again in FM, try adding user "fmxml" with full access in File->Define->Accounts & Priviledges under the Extended Priveleges tab. Make sure XML Publishing is on in the FMS Web Console at http://ipaddress/fmi/config.

Try restarting FileMaker and IIS services. You may also need to restart the console and/or the web server.

Try connecting via IWP. Turn it on in FM7 and the FMS Web Console. This will tell you if FMS7A is properly connecting to the FP7 file.

Try starting with a basic FindAll() FX.php action to test connectivity to a file.

Hope this helps.

Shannon

-=-=-

Do you think your possible solution of going back to PHP 4.x.x for XServe? I've been frustrated for weeks not being able to query FM databases through PHP. I have it working just fine with XML and stylesheets and I can get to the databases through IWP. But not PHP. I have PHP 5 installed currently.

Any help would be greatly appreciated.