RE: [suse-linux-uk-schools] OpenOffice.org + MySQL
It's a real one... In StarOffice the Adabas engine is preconfigured, so going to tools, datasources, then right-clicking on the dialogue box gets you the option to add new data source. Select Adabas as the type (presumably can be made default, not looked yet), click New Database, give it a name, set the password, enter the password (slightly annoying), click OK, wait... Now select the Tables tab, or the queries tab. What else is needed? Not my area, so that's as far as I get. -----Original Message----- From: Phil Driscoll To: Chris Puttick; 'Suse-Linux-Uk-Schools ' Sent: 11/12/02 11:05 AM Subject: Re: [suse-linux-uk-schools] OpenOffice.org + MySQL On Tuesday 12 November 2002 9:46 am, Chris Puttick wrote:
Had the CD for ages... Now on every computer in the site.
Chris Any opinions you would care to voice on how good the database element is? Cheers -- Phil Driscoll -- To unsubscribe, e-mail: suse-linux-uk-schools-unsubscribe@suse.com For additional commands, e-mail: suse-linux-uk-schools-help@suse.com
On Tuesday 12 November 2002 1:51 pm, Chris Puttick wrote:
It's a real one... In StarOffice the Adabas engine is preconfigured, so going to tools, datasources, then right-clicking on the dialogue box gets you the option to add new data source. Select Adabas as the type (presumably can be made default, not looked yet), click New Database, give it a name, set the password, enter the password (slightly annoying), click OK, wait...
Now select the Tables tab, or the queries tab. So far, so identical to using MySQL via odbc/jdbc.
What else is needed? Not my area, so that's as far as I get.
Anyone else actually using it? As I remeber the Adabas which came with SO 5.2 was knobbled in some way - maybe a limit on the number of tables or something. Do you end up saving a local file like an Access .mdb file? Cheers -- Phil Driscoll
On Tuesday 12 Nov 2002 3:18 pm, Phil Driscoll wrote:
On Tuesday 12 November 2002 1:51 pm, Chris Puttick wrote:
It's a real one... In StarOffice the Adabas engine is preconfigured, so going to tools, datasources, then right-clicking on the dialogue box gets you the option to add new data source. Select Adabas as the type (presumably can be made default, not looked yet), click New Database, give it a name, set the password, enter the password (slightly annoying), click OK, wait...
Now select the Tables tab, or the queries tab.
So far, so identical to using MySQL via odbc/jdbc.
What else is needed? Not my area, so that's as far as I get.
Anyone else actually using it? As I remeber the Adabas which came with SO 5.2 was knobbled in some way - maybe a limit on the number of tables or something. Do you end up saving a local file like an Access .mdb file?
<snip> StarOffice can access an Adabas D database if the latter has a version number 11.02 or higher. The following values apply to the Adabas D version 11 under StarOffice: Restricted to a max. of 100 MB and 3 users per database. Paul
Cheers
--- Chris Puttick <chris@centralmanclc.com> wrote: > It's a real one... In StarOffice the Adabas engine
is preconfigured, so going to tools, datasources, then right-clicking on the dialogue box gets you the option to add new data source. Select Adabas as the type (presumably can be made default, not looked yet), click New Database, give it a name, set the password, enter the password (slightly annoying), click OK, wait...
My SO6 installation on XP fell over horribly at the new database stage of Adabas data source. Got everything else working, except Adabas. Never had time to look further. Don't know about Adabas issues on SO6 with Linux. Incidently, the Oo.o that comes with RedHat 8 seems solid as a rock. AND users don't have to install it! Lovely for schools! - Matt __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com
participants (4)
-
Chris Puttick -
Matt Johnson -
Paul Taylor -
Phil Driscoll