PPCS

[JD Kromkowski]

If I don’t use a server – (I use network storage devices); I’m not sure how I actually set this up. I did in the past run some version of simpolserver on a machine and then was able to open forms and tables on multiple machines at once. But that would me that I’d have to have that machine always on – as opposed to just having the Network Storage devise and router always on (which it is). I’m not totally wrapping my head around on setting this up without having a server machine. I’ve never had more that 5 machines on the network – so over the years I just skipped the server issue.

[Michael]

On 07/08/2013 21:35, kromkowski wrote:
> If I don't use a server – (I use network storage devices); I'm not sure
> how I actually set this up.
>
> I did in the past run some version of simpolserver on a machine and then
> was able to open forms and tables on multiple machines at once. But that
> would me that I'd have to have that machine always on – as opposed to
> just having the Network Storage devise and router always on (which it is).
>
> I'm not totally wrapping my head around on setting this up without
> having a server machine. I've never had more that 5 machines on the
> network – so over the years I just skipped the server issue.
>

You either have to designate one of your machines a server and run the server on that, which means it always needs to be on when
access to the database is required, or else it has to run on the network storage device. Since that is probably not running either
Windows or an Intel-based Linux, then it is probably out. Just pick the machine that is most likely to be on most of the time when
the database will be required, even if that is a desktop machine. The actual files can be hosted there or on the network storage
device, that shouldn't make any difference.

Ciao, Neil

[JD Kromkowski]

That is what I surmised but I was hoping for some work around.

I am am using a number of WD Mybooks. I think in theory I can make them
actually web servers with Appache but that is a bit beyond my comfort level.

How much work does simpol server actually do? Could I just use something
from my "attic collection" like a really old xp machine and add it to
network with sole function of running simpol server and being on all the
time?

I really don't quite understand how simpol server works does every
request for data have to go first to the "server" machine and then to
Net Storage Device and then back to the machine running the smp?

On 08/09/13 12:58 PM, Neil Robinson wrote:
>
> You either have to designate one of your machines a server and run the server on that, which means it always needs to be on when
> access to the database is required, or else it has to run on the network storage device. Since that is probably not running either
> Windows or an Intel-based Linux, then it is probably out. Just pick the machine that is most likely to be on most of the time when
> the database will be required, even if that is a desktop machine. The actual files can be hosted there or on the network storage
> device, that shouldn't make any difference.
>
> Ciao, Neil
>

[Michael]

On 09/08/2013 19:00, kromkowski wrote:
> That is what I surmised but I was hoping for some work around.
>
> I am am using a number of WD Mybooks. I think in theory I can make them
> actually web servers with Appache but that is a bit beyond my comfort level.
>
> How much work does simpol server actually do? Could I just use something
> from my "attic collection" like a really old xp machine and add it to
> network with sole function of running simpol server and being on all the
> time?
>
> I really don't quite understand how simpol server works does every
> request for data have to go first to the "server" machine and then to
> Net Storage Device and then back to the machine running the smp?

The PPCS server is just a SIMPOL program that retrieves the database files from wherever they are stored and shares them on a
UDP/IP port. Your program connects to that database server program via the UPD/IP port (and IP address of course) instead of
accessing them directly via the file system. The server program is responsible for handling locking of tables and records,
committing saves and performing record deletes

Ciao, Neil

[Author]

Posts