I'm trying to setup an ISP Billing package called Optigold, which runs off of Filemaker Pro. Included in this package is a web interface which uses the Web Server Connector. I have tried and tried but cannot seem to get the web interface and the web connector to work properly.

I have FileMaker Pro 5.5 Unlimited and WebServer Connector installed on a Windows 2000 Server running IIS 5.5.

I have another Windows 2000 Server running FileMaker Server 5.5, which hosts the database.

The only time anything ever seems to work is when I have Optigold's database open in FileMaker on the db server. And it's only accessible by using the db server's IP address.

This leads me to believe that the database is being served by FileMaker Unlimited, not FileMaker Server. Could this be the case?

Any attempts to access the database through the webserver causes the browser to process for a very long time. If I look in IIS's log file hundreds of requests are made to the database CGI, and they all have a status 401.

I've also heard that for FM Server to work FileMaker has to have the database open on the machine. Is this true?

FM Unlimited does serve the databases to the web, so yes, FMUnlimited must have the databases open.

Thankfully, in FM7 FMS Advanced can serve it all.