Re: Questions about serving database



On Jul 9, 2:03 pm, David Averbach <dnaverb...@xxxxxxxxx> wrote:
I've only every really set up FM Server 7 on a closed intranet, and
not from a public IP address. In any case, I'm exploring different
options for a client who has a small home office with a staff that
works remotely out of their homes, and I want to know as much as I can
before making recommendations. All this would be the latest version
FileMaker 9, although I only have Filemaker Advanced 8.5 right now.

1) I know the computer that serves the database can be anything, but a
few years ago, FM recommended a dedicated computer and actually
recommended a PC over a Mac. What would people recommend as minimum
specs for a computer, and if my client environment is almost all mac,
should I really get a PC? Any negative experiences on a mac or pc
because it wasn't a good enough computer?

2) What about services like POINT IN SPACE? $60 seems like a lot to
serve two files. I know they have a free trial, but would access be
all that much faster than say, upgrading cable internet to a static IP
address and a fairly cheap PC?

3) I've set up my database with a data file, and a shell file. I might
want to add a few users that just need access to a tiny bit of the
information. Instead of dealing with complex permission and users and
groups, is there any problem with just creating an additional shell
database that will only access the parts of the database that I tell
it to and not the rest? In other words, is there any problem with
having two different shell databases accessing the same data file? I
don't think so, but I'm just checking

4) Has anyone had experience dealing with photos served remotely (i.e.
not on a local network). I tried this on our intranet and local was
fine, but across country was too slow. But that was a few years ago
with FM7. How about now access a host over an internet connection?

Thanks so much.

David Averbach

1) I think the dedicated server idea is a good one, but haven't heard
that PCs are preferred over Macs. Do you have a reference? I have
several clients set up on Mac Minis. Works great.

2) Point in Space is perhaps the most well-known server, but there are
others that are less expensive. I use MacUSA and find the customer
service excellent, though their administrative tools lack a little.
But even at $60/month, that's compared to $500 for a Mini, $900 for
Server 9, plus maintenence free server environment? If most of the
users will be connecting over the Internet, rather than an intranet, I
think a 3d party dedicated hosting service is hands down the winner.

3) The only real security in Filemaker is Access Privileges. But if
it's psuedo-security, aka more convenience than protection, then a
separate interface file is fine. And there's no issue I know of for
having different interface files.

4) Haven't had experience there so I can't help you.

Good luck,
G
.



Relevant Pages

  • Re: Mac file names too long??
    ... > Thank you for posting in SBS newsgroup. ... > networking settings on the MAC; modify the directory service options; ... > some settings on the SBS server need to be changed. ... > I. Check the TCP/IP properties of the MAC client. ...
    (microsoft.public.windows.server.sbs)
  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Remobjects v KBM
    ... >> client query components) follow from that. ... Then, connections can be created to say SQL Server, Oracle, Interbase and ... can then be created from the abstract dataset definition in 'customers' to ... implicitly - this makes your code not be database connection specific). ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Help with first VB application - Data Entry form
    ... stamp from the database machine - control machine ... ... unnecessary data to the client ... ... and when building a database independent UI / Client - Server application, ... JavaScript, for example) and thus, will get the time from the web server, ...
    (microsoft.public.dotnet.languages.vb)

Loading