Re: Newbie question(s)....

orbit wrote:
> 

Hi,

> Ah. My current install is an Ubuntu deb style package install which didn't include server option. But the OOo.org site doesn't seem to mention running Base as a server much, I found one reference that if you
> are doing a unix install from sources and want server capability, to run
> a command like 'setup/net' or something from the setup directory of
> the sources. Do you think I will need to re-install from scratch to get
> a server or can I enable the install that I have?

No, no, nothing like that. What Mechtilde meant is that you have to 
install the HSQLDB server on your machine that is going to host as a db 
server. Then activate it, and configure it with the necessary options. 
You have to be careful here because you will now have 2 hsqldb.jar files 
on your machine, the one that comes with OOo, and the one you've 
installed as a server, and they can conflict and cause OOo not to work 
properly, certainly at least in earlier versions of OOo2, or earlier 
versions of the HSQLDB server (below version 0.7 AFAIR). Then you'd have 
to recreate the connexion from within OOo to the HSQLDB server 
(specifying user access rights if any). Check out the HSQLDB 
documentation on the corresponding hsqldb.org website for further 
details of how to install and set up HSQLDB as a server process.


> Prolly 3 to 5 clients or individual stations/machines will need to access
> the database without interferring with each other. Base may be able to
> do all of this without MySQL as the applications are pretty simple and not very intensive. I just haven't found much info regarding Base/HSQL
> as a server on a lan.

Never tried the transactional row locking of HSQLDB from within Base so 
really wouldn't know. The best thing to do is to give each user his/her 
own copy of the ODB file.

Alex.


Alex