We've rolled out Open Office on all our dektop machines (Win NT, Win2K and LTSP). Everyone is happy except that they are starting to scream for database functionality - by which they actually machine something like MS Access. I've played with an ODBC connection to a locally hosted MySQL setup on a Windows box and the 'Form Autopilot' looks like it will do what we need. We have a Linux box suitably equipped to host MySQL databases for all the kids. I need to tackle the Windows clients first, and need to set things up so that when a kid logs in and runs Open Office they are automatically presented with their own database as a datasource. Has anyone done this yet? If so, advice would be most welcome. Cheers -- Phil Driscoll
On Mon, 2002-11-11 at 10:31, Phil Driscoll wrote:
We've rolled out Open Office on all our dektop machines (Win NT, Win2K and LTSP). Everyone is happy except that they are starting to scream for database functionality - by which they actually machine something like MS Access.
I've played with an ODBC connection to a locally hosted MySQL setup on a Windows box and the 'Form Autopilot' looks like it will do what we need.
We have a Linux box suitably equipped to host MySQL databases for all the kids. I need to tackle the Windows clients first, and need to set things up so that when a kid logs in and runs Open Office they are automatically presented with their own database as a datasource.
Has anyone done this yet? If so, advice would be most welcome.
Cheers -- Phil Driscoll
The database issue has been brought up with OO.org and its on the to-do list but I'm not sure for when! One of the reasons I'm developing the INGOT certification scheme is to generate some income to fund this type of developement. If anyone is interested in an internationally backed IT certificate for competence (similar to MS MOUS but a lot less expensive and with proceeds going to Open Source developement) E-mail me and I'll put you on my list. (Phil you are already on the list.) I expect to be get more detailed proposals out in the next couple of weeks. This is a way of getting all your KS4 pupils a certificate in IT skills without having to put them all through GCSE or an expensive alternative. Regards, -- IanL
On Monday 11 November 2002 9:14 pm, ian wrote:
The database issue has been brought up with OO.org and its on the to-do list but I'm not sure for when!
This may not be such a big issue for schools. When I had a brief play with the forms autopilot, it seemed to me that it did as much as I remeber things like Data Power doing - which amounts to 'enough', but with the advantage that we can also build web access to the same databases. Other resopondents mentioned Star Office: On the Star Office front, last time I played with the Star Office database was with version 5.2 a long while ago, but I remember not being very impressed with Adabas. Have things changed (for the better!) on that front? Cheers -- Phil Driscoll
participants (2)
-
ian -
Phil Driscoll