Serving FMP on a budget 
Author Message
 Serving FMP on a budget

We are running a heavily used FMP 4 application under Windows 98 file
sharing, and despite 64MB RAM the host is freezing up at least once per
week.  There are two primary users; 5 occasional guests mostly run
reports.  Corruption would be extremely bad news.

Since I have not seen FMP 5 yet, I don't know how wonderful the HTML
interface is.  The layouts were much too complex to build by hand with
CDML in 4.0, so I'll need guidance on whether to rely on the possibility
of web access with FMP 5.

Our non-web options appear to be:

1) FMP Server 5 / Windows NT Server = $3400.  Seven client upgrades =
$850.  Unless you tell me otherwise, I believe this would be a robust
solution that would make us all happy.  Does anyone have any concerns
about FMP Server 5? Is the absence of "updaters" a signal that the bugs
have not yet all shaken out?

[Despite all the discussions on this group, I'm not clear about HOW I
would serve web pages from Server-hosted databases.  I realize that
Server has no web connector.  Can a workstation running FMP provide a
web interface, or am I compelled to purchase the Unlimited product and
run it on the same server?]

2) FMP 5 / Windows NT dedicated workstation = $1600.  Seven client
upgrades = $850.  Both FMP and NT Workstation are limited to 10
concurrent connections.  This would suit our needs at present, and the
various pieces would be reusable later if we grow, so I feel there is no
financial risk.  But would it be reliable?  Does NT Workstation's
auto-disconnect feature (for idle users) create any risk of database
corruption?

Also, any reason to think that Windows 2000 Professional would be a
better platform at this time?

Your insights are most appreciated.  -Jefferson



Wed, 11 Sep 2002 03:00:00 GMT
 Serving FMP on a budget

Quote:

> Since I have not seen FMP 5 yet, I don't know how wonderful the HTML
> interface is.  The layouts were much too complex to build by hand with
> CDML in 4.0, so I'll need guidance on whether to rely on the possibility
> of web access with FMP 5.

Instant web publishing is more elegant with FM 5 IF you have built your
layouts using one of the web-friendly "themes" in 5...and if you don't
mind that the ONLY button functionality that works is "Go to Layout." No
scripts, no nothing.  You can edit portal records, but otherwise it's no
different than 4. Custom publishing is essentially the same, very work
intensive.

Quote:

> Our non-web options appear to be:

> 1) FMP Server 5 / Windows NT Server = $3400.  Seven client upgrades =
> $850.  Unless you tell me otherwise, I believe this would be a robust
> solution that would make us all happy.  Does anyone have any concerns
> about FMP Server 5? Is the absence of "updaters" a signal that the bugs
> have not yet all shaken out?

> [Despite all the discussions on this group, I'm not clear about HOW I
> would serve web pages from Server-hosted databases.  I realize that
> Server has no web connector.  Can a workstation running FMP provide a
> web interface, or am I compelled to purchase the Unlimited product and
> run it on the same server?]

Not sure why you need NT Server...if all you're doing is running FM
Server on NT using TCP/IP, but then I'm not an NT expert. I avoid it
like the plague.  Yes, it would be very robust.  To serve web files
while using FM Server to host, you dedicate a SECOND server machine, run
Filemaker Unlimited, which guests into the hosted files and serves them
to the web. This second server machine can also run FM itself instead of
Unlimited if less than 10 IPs will connect in any 24 hour period.

Quote:

> 2) FMP 5 / Windows NT dedicated workstation = $1600.  Seven client
> upgrades = $850.  Both FMP and NT Workstation are limited to 10
> concurrent connections.  This would suit our needs at present, and the
> various pieces would be reusable later if we grow, so I feel there is no
> financial risk.  But would it be reliable?  Does NT Workstation's
> auto-disconnect feature (for idle users) create any risk of database
> corruption?

There are issues with various Service Packs for NT which you can
research on the FM website in their Techinfo articles. Personally, I'd
get a Mac. ;)

Quote:

> Also, any reason to think that Windows 2000 Professional would be a
> better platform at this time?

I do not know if Filemaker, particularly the Server version, is
certified to run under W2000.

--

Allen & Allen Semiotics, Inc.              Web & Graphic Design
Long Beach CA USA         Filemaker Pro Consulting - Member FSA
562.938.7890  fax 562.938.7891      Custom Solutions & Training



Thu, 12 Sep 2002 03:00:00 GMT
 Serving FMP on a budget
According to the FMI website FMP 5.0 is Windows 2000 compliant.  But I am
concerned that Jefferson was inquiring as to using the web to access his
databases for use by users within his office to create, modify and delete
records.  FMI does not advise doing this for many reasons.  You will be best
served in staying with the server client environment and use web pages to serve
applicatios to the general public..

Steven Scharf
SCS Media Services
57 East 11th Street, 9th Floor
New York, New York 10003
212-822-8555


Quote:

> Since I have not seen FMP 5 yet, I don't know how wonderful the HTML
> interface is.  The layouts were much too complex to build by hand with
> CDML in 4.0, so I'll need guidance on whether to rely on the possibility
> of web access with FMP 5.

Instant web publishing is more elegant with FM 5 IF you have built your
layouts using one of the web-friendly "themes" in 5...and if you don't
mind that the ONLY button functionality that works is "Go to Layout." No
scripts, no nothing.  You can edit portal records, but otherwise it's no
different than 4. Custom publishing is essentially the same, very work
intensive.

Quote:

> Our non-web options appear to be:

> 1) FMP Server 5 / Windows NT Server = $3400.  Seven client upgrades =
> $850.  Unless you tell me otherwise, I believe this would be a robust
> solution that would make us all happy.  Does anyone have any concerns
> about FMP Server 5? Is the absence of "updaters" a signal that the bugs
> have not yet all shaken out?

> [Despite all the discussions on this group, I'm not clear about HOW I
> would serve web pages from Server-hosted databases.  I realize that
> Server has no web connector.  Can a workstation running FMP provide a
> web interface, or am I compelled to purchase the Unlimited product and
> run it on the same server?]

Not sure why you need NT Server...if all you're doing is running FM
Server on NT using TCP/IP, but then I'm not an NT expert. I avoid it
like the plague.  Yes, it would be very robust.  To serve web files
while using FM Server to host, you dedicate a SECOND server machine, run
Filemaker Unlimited, which guests into the hosted files and serves them
to the web. This second server machine can also run FM itself instead of
Unlimited if less than 10 IPs will connect in any 24 hour period.

Quote:

> 2) FMP 5 / Windows NT dedicated workstation = $1600.  Seven client
> upgrades = $850.  Both FMP and NT Workstation are limited to 10
> concurrent connections.  This would suit our needs at present, and the
> various pieces would be reusable later if we grow, so I feel there is no
> financial risk.  But would it be reliable?  Does NT Workstation's
> auto-disconnect feature (for idle users) create any risk of database
> corruption?

There are issues with various Service Packs for NT which you can
research on the FM website in their Techinfo articles. Personally, I'd
get a Mac. ;)

Quote:

> Also, any reason to think that Windows 2000 Professional would be a
> better platform at this time?

I do not know if Filemaker, particularly the Server version, is
certified to run under W2000.

--

Allen & Allen Semiotics, Inc.              Web & Graphic Design
Long Beach CA USA         Filemaker Pro Consulting - Member FSA
562.938.7890  fax 562.938.7891      Custom Solutions & Training



Thu, 12 Sep 2002 03:00:00 GMT
 Serving FMP on a budget

Quote:


> > Since I have not seen FMP 5 yet, I don't know how wonderful the HTML
> > interface is.  The layouts were much too complex to build by hand with
> > CDML in 4.0, so I'll need guidance on whether to rely on the possibility
> > of web access with FMP 5.

> Instant web publishing is more elegant with FM 5 IF you have built your
> layouts using one of the web-friendly "themes" in 5...and if you don't
> mind that the ONLY button functionality that works is "Go to Layout." No
> scripts, no nothing.  You can edit portal records, but otherwise it's no
> different than 4. Custom publishing is essentially the same, very work
> intensive.

I feared as much.  I don't want to redesign the layouts from scratch,
and they all run off scripts with mutiple-criteria screens.

Quote:

> > Our non-web options appear to be:

> > 1) FMP Server 5 / Windows NT Server = $3400.  Seven client upgrades =
> > $850.  Unless you tell me otherwise, I believe this would be a robust
> > solution that would make us all happy.  Does anyone have any concerns
> > about FMP Server 5? Is the absence of "updaters" a signal that the bugs
> > have not yet all shaken out?

> > [Despite all the discussions on this group, I'm not clear about HOW I
> > would serve web pages from Server-hosted databases.  I realize that
> > Server has no web connector.  Can a workstation running FMP provide a
> > web interface, or am I compelled to purchase the Unlimited product and
> > run it on the same server?]

> Not sure why you need NT Server...if all you're doing is running FM
> Server on NT using TCP/IP, but then I'm not an NT expert. I avoid it
> like the plague.  Yes, it would be very robust.  To serve web files

Is it okay to admit I don't have a lot of Mac experience?  NT looks a
lot like Windows 95, but has a more stable core and is better designed.
If we didn't already have 3 NT Server machines with enough licenses for
everyone in the house, it would be cost prohibitive to start now.

- Show quoted text -

Quote:
> while using FM Server to host, you dedicate a SECOND server machine, run
> Filemaker Unlimited, which guests into the hosted files and serves them
> to the web. This second server machine can also run FM itself instead of
> Unlimited if less than 10 IPs will connect in any 24 hour period.

> > 2) FMP 5 / Windows NT dedicated workstation = $1600.  Seven client
> > upgrades = $850.  Both FMP and NT Workstation are limited to 10
> > concurrent connections.  This would suit our needs at present, and the
> > various pieces would be reusable later if we grow, so I feel there is no
> > financial risk.  But would it be reliable?  Does NT Workstation's
> > auto-disconnect feature (for idle users) create any risk of database
> > corruption?

> There are issues with various Service Packs for NT which you can
> research on the FM website in their Techinfo articles. Personally, I'd
> get a Mac. ;)

I think I'm going to go with plan 2 and see how it works out.  It can
only be better than what we have now.  If there's a G4 in my future, I
certainly won't object, but Apple's "server" pricing is pretty high.

- Show quoted text -

Quote:

> > Also, any reason to think that Windows 2000 Professional would be a
> > better platform at this time?

> I do not know if Filemaker, particularly the Server version, is
> certified to run under W2000.

> --

> Allen & Allen Semiotics, Inc.              Web & Graphic Design
> Long Beach CA USA         Filemaker Pro Consulting - Member FSA
> 562.938.7890  fax 562.938.7891      Custom Solutions & Training



Fri, 13 Sep 2002 03:00:00 GMT
 Serving FMP on a budget
You scare the heck out of me when you say "under Windows 98 file sharing"

Tell me, do clients share the host machine's hard drive, and double
click the filemaker file icons to start the solution? BAD!!!!!

Or

Do they go to the Open menu item, and press the Hosts button, then
select the desired file from the resulting list (or do the same via a
script) GOOD!!!

If they are doing the first one, turn off file sharing on that hard
drive because you don't want them doing that. You really really really
don't. Did I mention that you don't want them doing that?

Quote:

> We are running a heavily used FMP 4 application under Windows 98 file
> sharing, and despite 64MB RAM the host is freezing up at least once per
> week.  There are two primary users; 5 occasional guests mostly run
> reports.  Corruption would be extremely bad news.



Fri, 13 Sep 2002 03:00:00 GMT
 Serving FMP on a budget

Quote:
(Lynn Allen) writes:
>Instant web publishing is more elegant with FM 5 IF you have built your
>layouts using one of the web-friendly "themes" in 5...and if you don't
>mind that the ONLY button functionality that works is "Go to Layout." No
>scripts, no nothing.  You can edit portal records, but otherwise it's no
>different than 4. Custom publishing is essentially the same, very work
>intensive.

Is there any other way to access scripts in Instant web publishing. Do startup
scripts work?
Steve Andrews
Andrews Technologies Management


Fri, 13 Sep 2002 03:00:00 GMT
 Serving FMP on a budget
Quote:

> You scare the heck out of me when you say "under Windows 98 file sharing"

> Tell me, do clients share the host machine's hard drive, and double
> click the filemaker file icons to start the solution? BAD!!!!!

> Or

> Do they go to the Open menu item, and press the Hosts button, then
> select the desired file from the resulting list (or do the same via a
> script) GOOD!!!

Be very afraid...

I consulted FileMaker.com, and found a recent article (#101295
Optimizing Network Performance for Shared Databases, 9/28/1999) warning
"(Windows) Do not double-click on the file icon on a mapped volume, or
on the volume in your network neighborhood. Actually, for other reasons
not related to speed, Windows users should not open a database in this
way. Always connect via the Hosts button or an opener database."
Another article (#104759 Troubleshooting Windows NT Access Violation
(C0000005) Errors, 9/28/1999) explained:
---
FileMaker can experience recurring problems if clients circumvent (by
using shortcuts to networked files, for example) the networking built
into FileMaker Pro. We have some instances of Access Violation occurring
when sharing is active on the FMServer directory.

FileMaker Pro uses it's own networking, NOT Windows networking to share
access to a file. (Refer to your FileMaker Pro manual for specific
information regarding networking.) This means you should not share the
FileMaker Pro directory on the server machine. Often the server
directory is shared when guests are mapping the FMServer directory as a
network drive and launching the files from there. This is an improper
method of accessing FileMaker files. For this reason, please make sure
that file sharing is turned off for the FileMaker server machine. Guests
should ALWAYS launch their own copies of FileMaker, go to the File menu,
select Open and click the Hosts button.
---
We will mend our ways.  Thanks for the tip.



Fri, 13 Sep 2002 03:00:00 GMT
 Serving FMP on a budget
According to the FMP5 Server Manual, it is intended for Windows 2000 (both
versions), as well as NT, although I cannot seem to find a sentence
actually stating that it is so certified.
John weinshel
datagrace

--
Posted via CNET Help.com
http://www.help.com/



Sat, 14 Sep 2002 03:00:00 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. CDML COMMAND:[fmp-linkfirst] [fmp-linknext] [fmp-linklast] [fmp-linkprevious]

2. FMP 3.0 serving 4.0 dbs

3. To Serve Or Not To Serve

4. Will FMP 4 read FMP 1?

5. Help FMP Server and FMP Pro

6. Query between FMP Server and FMP Unlimited

7. fmp server & fmp unlimited

8. FMP 5.5 and FMP 5 for the same file

9. FMP Unlimited WITHOUT FMP Server

10. FMP 5 Server vs FMP 5 file hosting, Part II

11. FMP 5 Server vs FMP 5 file hosting

12. Most effective way to setup FMP U and FMP Server


 
Powered by phpBB® Forum Software