Re: [libreoffice-users] Re: Another question concerning Base

[Tom Davies <tomdavies04@yahoo.co.uk>]

Hi :)
I thought the MySql / MariaDb connector was compiled for very specific OSes and versions of LO?  I thought the working ones were on the LO Extensions website?  
Regards from
Tom :)  


--- On Mon, 20/8/12, Dan <elderdanlewis@gmail.com> wrote:

From: Dan <elderdanlewis@gmail.com>
Subject: Re: [libreoffice-users] Re: Another question concerning Base
To: users@global.libreoffice.org
Date: Monday, 20 August, 2012, 22:24

Girvin R. Herr wrote:
>
>
> Alexander Thurgood wrote:
>> Le 16/08/12 00:56, Thomas Taylor a écrit :
>>
>> Hi Thomas,
> 8><..
>
>> - AOOo has moved its hsqldb engine to an improved version 2, whereas LO
>> is still stuck on version 1.8 ;
>>
>> - AOOo has removed direct support for the mysql native connector due to
>> licensing issues, it is still provided as a download for older versions
>> of OOo, but is no longer being actively supported ;
>>
>> - LO no longer has any actively supported native mysql connector either,
>> but for the moment, an attempt to not break the existing external
>> extension is being maintained ;
>>
>> - LO has read/write native connector support for postgresql - this, I
>> believe, is a major improvement over AOOo, which only had read support,
>> and the postgres native connector is no longer even offered with AOOo
>> due to licensing issues ;
>>
>> - both AOOo and LO support JDBC driver connections to postgresql and
>> mysql databases ;
>>
>> - both AOOo and LO are supposed to support ODBC driver connections -
>> however, this is very dependent on OS, bit version architecture (32/64)
>> and buggy behaviours of the 3rd party drivers ;
>>
>> - LO support of MS Access databases on Windows is variable according to
>> LO version and Access mdb/accdb version - one day it works with one
>> version of LO, the next it doesn't, so your mileage may vary - I can't
>> speak for AOOo here as I haven't tested that bit ;
>>
>> - Access databases are not supported in either LO or AOOo on other OSes
>> (i.e. Linux/Mac), to my knowledge - these are usually dealt with by 3rd
>> party programs.
>>
>> This is only a short comparison, I'm sure there are other points that
>> could be mentioned, but on the whole, the basic DB functionality between
>> the two is pretty much the same. That situation is likely to change with
>> the switch to LO version 4 development, where it has already been
>> decided that backwards version (ABI) compatibility for all
>> functionalities of the LO suite will not be guaranteed. At the moment, I
>> have no idea how that will affect Base, but it will almost certainly
>> affect any extensions that are currently available.
>>
>>
>> Alex
>>
>>
> Alexander,
> Thanks for this information.  It is very enlightening, so I shouldn't be
> too surprised in the future.  I use Base extensively as a client to MySQL.
> Girvin Herr

      For the present, the MySQL Connector 1.0.1 still works for both 
AOO 3.4 (I use 3.4.1, a pre-release) and LO 3.4.6, 3.5.6.2, and 3.6.0.4.
      For how long this will be true? Only the DEV people may know 
unless someone decides to update this extension in the future for any 
changes made in AOO and LO.

--Dan

-- 
For unsubscribe instructions e-mail to: users+help@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+help@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