Re: [libreoffice-users] How get LibreO-Base working?

2012-01-31 Thread Jay Lozier

On 01/31/2012 08:23 PM, Tom Davies wrote:

Hi :)
Last i heard the Postgresql people were working more closely with Base than the 
MariaDb people who seem to be busy with their own side of things.  No word at 
all from the MySql community.  The MySql connector apparently works with 
MariaDb or at least we have never had anyone grumbling about it.
MariaDB is designed as a drop-in replacement for MySQL. It uses the same 
file names as MySQL so programs/apps that depend on MySQL should not 
break when switching to MariaDB.


I keep forgetting about SQLite.  It sounds likely to be light but is it free of 
java?

According to Wikipedia it is written in C

Regards from
Tom :)


--- On Wed, 1/2/12, Jay Lozier  wrote:

From: Jay Lozier
Subject: Re: [libreoffice-users] How get LibreO-Base working?
To: users@global.libreoffice.org
Date: Wednesday, 1 February, 2012, 1:05

On 01/31/2012 05:35 PM, Tom Davies wrote:

Hi :
i would go with Andreas' suggestion.  An external back-end but finding a small 
non-Java-dependant one might be tricky.  MySql and it's fork (successor?) 
MariaDb are probably too heavy.  Is Postgresql better for smaller databases?

A small database back-end that might be suitable is SQLite. Personally I
prefer MySQL/MariaDB over Postgresql because more third-party
documentation is available and I think Postgresql is heavier.

If you have to have java then the best one seems to be 6u21.  If you can get it 
all working with a newer version then great but past the 6u24 they seem to 
cause increasing problems.  I was really hoping that 3.5.x would allow people 
to use java 7.  I didn't realise there was already an 8!!  Has 7 already been 
found to have serious security issues?

Regards from
Tom :)


--- On Tue, 31/1/12, Pertti Rönnberg   wrote:

From: Pertti Rönnberg
Subject: [libreoffice-users] How get LibreO-Base working?
To: "Users LibreOffice"
Date: Tuesday, 31 January, 2012, 18:31

Dear Ladies and Gentlemen  out there.
I am confused -- can you help  me? I recently installed LibreOffice-v3.4.5 after beeing a happy OO-user in many 
many years. I now need to make a couple of relational databases (subforms&-reports) and decided to try 
LibreO's Base. On my main-PC (AMD Athlon II X3 445, Win7Prof/32bit) the LO's Base caused the program to stop 
(Write&Calc work OK). I uninstalled LO, removed folders via WinExplorer, rebooted, installed LOv3.4.5 again 
and when asked for a new JRE I tried to understand the instructions found and first installed JRE8 
(jre-8-ea-bin-b21-windows-i586-13_jan_2012.exe) and then JRE7 (jre-7u2-windows-i586.exe) and loaded both as 
instructed into LO (LO-page: tools/options/LibreOffice/java). Now LO didn't stop but neither of the JREs seem to 
be sufficient /"LibreO requires a JRE to perform this task. The selected JRE is defective. Please select 
and install a new JRE/" and then "/connection to datasource ("db-name") could not be 
established -- no Java
installation could be found; check installation/". I did my best several 
times.
Note. After doing exactly same install process on my laptop (Win7Prem/64bit) 
the LO(64bit), Base included, works fine.
Did I do something wrong, wrong versions, is it the 32bit make of LO or the 
LO-Base itself, is the JRE(32bit) wrong, -- or what? I like the graphical 
interface but I don't want to go back to OO and I don't want to buy a MSAccess, 
and for my simple needs a MySQL/PHP/Apache seems too heavy to learn.
Thanks in advance.
Pepe Rönnberg (Finland)


-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted







--
Jay Lozier
jsloz...@gmail.com



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] How get LibreO-Base working?

2012-01-31 Thread Tom Davies
Hi :)
Last i heard the Postgresql people were working more closely with Base than the 
MariaDb people who seem to be busy with their own side of things.  No word at 
all from the MySql community.  The MySql connector apparently works with 
MariaDb or at least we have never had anyone grumbling about it.  

I keep forgetting about SQLite.  It sounds likely to be light but is it free of 
java?
Regards from
Tom :)


--- On Wed, 1/2/12, Jay Lozier  wrote:

From: Jay Lozier 
Subject: Re: [libreoffice-users] How get LibreO-Base working?
To: users@global.libreoffice.org
Date: Wednesday, 1 February, 2012, 1:05

On 01/31/2012 05:35 PM, Tom Davies wrote:
> Hi :
> i would go with Andreas' suggestion.  An external back-end but finding a 
> small non-Java-dependant one might be tricky.  MySql and it's fork 
> (successor?) MariaDb are probably too heavy.  Is Postgresql better for 
> smaller databases?
A small database back-end that might be suitable is SQLite. Personally I 
prefer MySQL/MariaDB over Postgresql because more third-party 
documentation is available and I think Postgresql is heavier.
>
> If you have to have java then the best one seems to be 6u21.  If you can get 
> it all working with a newer version then great but past the 6u24 they seem to 
> cause increasing problems.  I was really hoping that 3.5.x would allow people 
> to use java 7.  I didn't realise there was already an 8!!  Has 7 already been 
> found to have serious security issues?
>
> Regards from
> Tom :)
>
>
> --- On Tue, 31/1/12, Pertti Rönnberg  wrote:
>
> From: Pertti Rönnberg
> Subject: [libreoffice-users] How get LibreO-Base working?
> To: "Users LibreOffice"
> Date: Tuesday, 31 January, 2012, 18:31
>
> Dear Ladies and Gentlemen  out there.
> I am confused -- can you help  me? I recently installed LibreOffice-v3.4.5 
> after beeing a happy OO-user in many many years. I now need to make a couple 
> of relational databases (subforms&-reports) and decided to try LibreO's Base. 
> On my main-PC (AMD Athlon II X3 445, Win7Prof/32bit) the LO's Base caused the 
> program to stop (Write&Calc work OK). I uninstalled LO, removed folders via 
> WinExplorer, rebooted, installed LOv3.4.5 again and when asked for a new JRE 
> I tried to understand the instructions found and first installed JRE8 
> (jre-8-ea-bin-b21-windows-i586-13_jan_2012.exe) and then JRE7 
> (jre-7u2-windows-i586.exe) and loaded both as instructed into LO (LO-page: 
> tools/options/LibreOffice/java). Now LO didn't stop but neither of the JREs 
> seem to be sufficient /"LibreO requires a JRE to perform this task. The 
> selected JRE is defective. Please select and install a new JRE/" and then 
> "/connection to datasource ("db-name") could not be established -- no Java
>   installation could be found; check installation/". I did my best several 
>times.
> Note. After doing exactly same install process on my laptop (Win7Prem/64bit) 
> the LO(64bit), Base included, works fine.
> Did I do something wrong, wrong versions, is it the 32bit make of LO or the 
> LO-Base itself, is the JRE(32bit) wrong, -- or what? I like the graphical 
> interface but I don't want to go back to OO and I don't want to buy a 
> MSAccess, and for my simple needs a MySQL/PHP/Apache seems too heavy to learn.
> Thanks in advance.
> Pepe Rönnberg (Finland)
>
>
> -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems? 
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>
>


-- 
Jay Lozier
jsloz...@gmail.com



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] How get LibreO-Base working?

2012-01-31 Thread Jay Lozier

On 01/31/2012 05:35 PM, Tom Davies wrote:

Hi :
i would go with Andreas' suggestion.  An external back-end but finding a small 
non-Java-dependant one might be tricky.  MySql and it's fork (successor?) 
MariaDb are probably too heavy.  Is Postgresql better for smaller databases?
A small database back-end that might be suitable is SQLite. Personally I 
prefer MySQL/MariaDB over Postgresql because more third-party 
documentation is available and I think Postgresql is heavier.


If you have to have java then the best one seems to be 6u21.  If you can get it 
all working with a newer version then great but past the 6u24 they seem to 
cause increasing problems.  I was really hoping that 3.5.x would allow people 
to use java 7.  I didn't realise there was already an 8!!  Has 7 already been 
found to have serious security issues?

Regards from
Tom :)


--- On Tue, 31/1/12, Pertti Rönnberg  wrote:

From: Pertti Rönnberg
Subject: [libreoffice-users] How get LibreO-Base working?
To: "Users LibreOffice"
Date: Tuesday, 31 January, 2012, 18:31

Dear Ladies and Gentlemen  out there.
I am confused -- can you help  me? I recently installed LibreOffice-v3.4.5 after beeing a happy OO-user in many 
many years. I now need to make a couple of relational databases (subforms&-reports) and decided to try 
LibreO's Base. On my main-PC (AMD Athlon II X3 445, Win7Prof/32bit) the LO's Base caused the program to stop 
(Write&Calc work OK). I uninstalled LO, removed folders via WinExplorer, rebooted, installed LOv3.4.5 again 
and when asked for a new JRE I tried to understand the instructions found and first installed JRE8 
(jre-8-ea-bin-b21-windows-i586-13_jan_2012.exe) and then JRE7 (jre-7u2-windows-i586.exe) and loaded both as 
instructed into LO (LO-page: tools/options/LibreOffice/java). Now LO didn't stop but neither of the JREs seem to 
be sufficient /"LibreO requires a JRE to perform this task. The selected JRE is defective. Please select 
and install a new JRE/" and then "/connection to datasource ("db-name") could not be 
established -- no Java
  installation could be found; check installation/". I did my best several 
times.
Note. After doing exactly same install process on my laptop (Win7Prem/64bit) 
the LO(64bit), Base included, works fine.
Did I do something wrong, wrong versions, is it the 32bit make of LO or the 
LO-Base itself, is the JRE(32bit) wrong, -- or what? I like the graphical 
interface but I don't want to go back to OO and I don't want to buy a MSAccess, 
and for my simple needs a MySQL/PHP/Apache seems too heavy to learn.
Thanks in advance.
Pepe Rönnberg (Finland)


-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted





--
Jay Lozier
jsloz...@gmail.com



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] How get LibreO-Base working?

2012-01-31 Thread Tom Davies
Hi :
i would go with Andreas' suggestion.  An external back-end but finding a small 
non-Java-dependant one might be tricky.  MySql and it's fork (successor?) 
MariaDb are probably too heavy.  Is Postgresql better for smaller databases?  

If you have to have java then the best one seems to be 6u21.  If you can get it 
all working with a newer version then great but past the 6u24 they seem to 
cause increasing problems.  I was really hoping that 3.5.x would allow people 
to use java 7.  I didn't realise there was already an 8!!  Has 7 already been 
found to have serious security issues?

Regards from
Tom :)


--- On Tue, 31/1/12, Pertti Rönnberg  wrote:

From: Pertti Rönnberg 
Subject: [libreoffice-users] How get LibreO-Base working?
To: "Users LibreOffice" 
Date: Tuesday, 31 January, 2012, 18:31

Dear Ladies and Gentlemen  out there.
I am confused -- can you help  me? I recently installed LibreOffice-v3.4.5 
after beeing a happy OO-user in many many years. I now need to make a couple of 
relational databases (subforms &-reports) and decided to try LibreO's Base. On 
my main-PC (AMD Athlon II X3 445, Win7Prof/32bit) the LO's Base caused the 
program to stop (Write&Calc work OK). I uninstalled LO, removed folders via 
WinExplorer, rebooted, installed LOv3.4.5 again and when asked for a new JRE I 
tried to understand the instructions found and first installed JRE8 
(jre-8-ea-bin-b21-windows-i586-13_jan_2012.exe) and then JRE7 
(jre-7u2-windows-i586.exe) and loaded both as instructed into LO (LO-page: 
tools/options/LibreOffice/java). Now LO didn't stop but neither of the JREs 
seem to be sufficient /"LibreO requires a JRE to perform this task. The 
selected JRE is defective. Please select and install a new JRE/" and then 
"/connection to datasource ("db-name") could not be established -- no Java
 installation could be found; check installation/". I did my best several times.
Note. After doing exactly same install process on my laptop (Win7Prem/64bit) 
the LO(64bit), Base included, works fine.
Did I do something wrong, wrong versions, is it the 32bit make of LO or the 
LO-Base itself, is the JRE(32bit) wrong, -- or what? I like the graphical 
interface but I don't want to go back to OO and I don't want to buy a MSAccess, 
and for my simple needs a MySQL/PHP/Apache seems too heavy to learn.
Thanks in advance.
Pepe Rönnberg (Finland)


-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-users] How get LibreO-Base working?

2012-01-31 Thread Pertti Rönnberg

Dear Ladies and Gentlemen  out there.
I am confused -- can you help  me? I recently installed 
LibreOffice-v3.4.5 after beeing a happy OO-user in many many years. I 
now need to make a couple of relational databases (subforms &-reports) 
and decided to try LibreO's Base. On my main-PC (AMD Athlon II X3 445, 
Win7Prof/32bit) the LO's Base caused the program to stop (Write&Calc 
work OK). I uninstalled LO, removed folders via WinExplorer, rebooted, 
installed LOv3.4.5 again and when asked for a new JRE I tried to 
understand the instructions found and first installed JRE8 
(jre-8-ea-bin-b21-windows-i586-13_jan_2012.exe) and then JRE7 
(jre-7u2-windows-i586.exe) and loaded both as instructed into LO 
(LO-page: tools/options/LibreOffice/java). Now LO didn't stop but 
neither of the JREs seem to be sufficient /"LibreO requires a JRE to 
perform this task. The selected JRE is defective. Please select and 
install a new JRE/" and then "/connection to datasource ("db-name") 
could not be established -- no Java installation could be found; check 
installation/". I did my best several times.
Note. After doing exactly same install process on my laptop 
(Win7Prem/64bit) the LO(64bit), Base included, works fine.
Did I do something wrong, wrong versions, is it the 32bit make of LO or 
the LO-Base itself, is the JRE(32bit) wrong, -- or what? I like the 
graphical interface but I don't want to go back to OO and I don't want 
to buy a MSAccess, and for my simple needs a MySQL/PHP/Apache seems too 
heavy to learn.

Thanks in advance.
Pepe Rönnberg (Finland)


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted