PigDog

THANKS! I just wonder if something else is a foot here. My setup has the iMac host sitting in a DMZ on my LinkSys router. All traffic coming in, is coming through with a single IP address, that of the router itself, not my external IP. At one point I was thinking that it was a mix of the number of open databases with connections. If what you say, is correct, how is it that 2 or 3 people have connect problems. I am in test mode right now. I expect I may need FMP unlimited in the future. I think something else is in the mix. As always, thanks,

Hello All, Another question... Anyone know how the guest limit (preset to 10) is counted? Is it 10 connections to one database file? Is it 10 total connections of database and actual access? When do these timers reset? The doc is really lacking on this? Is it 10 connections in the 12 hour period of time mentioned? Up until a few minutes ago, I've been able to access my site over the net without a problem. I've checked my IP address and reset it via the router. Both computers can access the internet but not the IP for the application. I tried changing the port number from 80 to 591 with no change in the result. I have also rebooted the host machine. I will now reboot this one. Thanks again! PigDog

I wanted to post some info that I hope would be helpful to those implementing an Instant Publishing Web Companion database. Expedience was the key driver. Elegance of database design was not. Functional and well designed web pages are absolutely necessary. That's where the extra effort went. So, please don't criticize any implementation details. They worked for me. Lessons learned: Keep in simple. Keep number of pages to a minimum. Be willing to change the flow and rework the way you implement once you begin to understand what's going on. Some of you initial conceptions and design considerations may likely change. Use a readable font. My database will be hosted on a Mac but I expect mostly PC connections to it. My recommendation for a web-friendly font is Verdana (system font both platforms). FYI, it's the font used at Lycos. What works in FMP the application, may not work over the Internet. Local testing works very well. But I'd recommend you get the internet connection up and running as soon as practical. Better to test this way if you can. A 384 bi-directional DSL connection seems to perform quite well. More on this later as I have friends connect and try... Host machine will be an G3 iMac 400. We'll see if this has to change. The FM documentation seems to have most of what you need. The help files have some of details that you seem to have to stumble across. For major issues, the doc was fine and their scenarios worked! If dealing with data entry and record creation, and if subsequent ordering of records is an issue, I suggest a time stamp be used (creation date + creation time) as a number be used. What seems to happen (looking at the logs) is that with each request, whatever sort you specify in the companion set up views is used. This can have interesting results when you think the order is one way and it can be different. IE doesn't like empty databases. It barks and will say you don't have edit privileges. I ended up creating one record in FMP that the user updates on the web to get around this. I could probably code around this now. Check that the browser has scripting and plug-ins enabled. To get my work done quickly I ended up putting my data collection into one database. Originally I had 2 related files. I hit a wall early and changed my approach. I guess what I am trying to say, is be flexible. I gave up on the relationships working. I will have multiple files for multiple people, so in the end, it makes sense for fewer files. My end use allows for this. All data will be aggregatge later. For other folks, it may not. This is my point about expedience and simplicity. No elegance here! I used Instant Publishing with my own navigation in the pages. I took very little notice of the IP UI. I will instruct my end users to use the navigation in the middle of the page. Again, not elegant. I didn't feel as thought I had the time to figure their stuff out. I am using FMP out of the box; not the developer edition. I wanted to control the end user experience. An no, I didn't have Home Page available and I am not an html guru to build pages. The ads said I could use FM out of the box to do this and that's what I built. Really, and it works! When I have the chance I will create a Home Page front end. Ironically, I just gave away the software. I have since asked for it back! All things considered, it WORKED surprisingly easy! Obviously I talked to myselft alot and put a lot of hours into it, but I'm pleased enough to write this and encourage others to do the same. I hope FM folks see this and put some effort into documenting some of the aspects and particulary to provide examples. That is sorely needed. Be well, PigDog aka Howard

Thank you all very much for your VERY timely responses that have been most helpful! I had looked in help with "error codes" but did not try help for the status(currenterror). THANKS Again! Howard Hello All! Anyone know what error code 102 is? I am trying to enter some data remotely over the internet and i get this error message about not having access to edit. I did access the tech info base and found article 106794. Only thing, was that I could not access it. Many thanks, PigDog (aka Howard) hcoffman_dd@yahoo.com [ November 25, 2001: Message edited by: PigDog ] [ November 25, 2001: Message edited by: PigDog ]