Hi
It is going to take more than 1 more person to sort out Base. We need to find a way of getting a whole load of people involved. The BoD has decided to just sit&wait and is happy to leave it to chance and natural progression (ie waiting for devs to move beyond Writer and Calc towards the more interesting challenges presented by Base). There is a bit more activity in OpenOffice.org so perhaps we should just wait and see if we can use whatever happens there! LibreOffice has higher priorities than sorting out Base as Base is fine for most people most of the time apparently.
Regards from
Tom
Hi Ian,
OK - I've been doing some Googling on this problem.
It seems to be known about and is listed as 'Bug 32948'.
Does anyone know what the current status of this bug is? Or seen as Alex
Thurgood's name comes up a lot in the Bug Report does anyone have his
eMail address so that we can get an update on this??
That would be me, and you already have my e-mail address, since we have
previously exchanged comms on another db problem.
As I have just reported on the bug issue 32948, the Address Book
Datasource Wizard works for me with my most recent build of LO source
from master.
Alex
Hi Ian,
It seems to be known about and is listed as 'Bug 32948'.
This bug is related to the Address Datasource wizard, not HSQLDB ?
Alex
Hi Heinrich,
I can only agree with you. The only connector that works really well is the
native one. Using ODBC is "buggy" and the Java-Connector is (for the
Java state
of affairs!) sooooo slow!
The old mysql connector versions (i.e. the Oracle ones) should now work
again on Windows, at least in 3.5RC2 (if Fridrich Strba's changes have
been integrated, which they should have been by now).
I am not building on Windows, and so I won't be providing a mysql
connector based on current master code source. I only provide for Mac
and (Ubuntu) Linux 32bit from master (and not from previous versions of LO).
But I don't get what all this has to do with HSQLDB, which was Ian's
initial problem ?
Alex
Hi,
Has this database been registered with LibreOffice? go to
LibreOffice Base>Databases
Don
Hi Alex,
I have LO 3.3 installed on Windows/Vista and Linux-Mint-Lisa. The native MySQL-Connector
worked flawlessly - at least for what I use it. As a "fall-back" I still use the Vista-
System. But, when going to 3.5.0-RC2 today, I saw that - as I had already noticed earlier
on, the connector cannot be activated. ODBC works - well, kind of!
I have never built anything from source in LO. Could you point me in the right direction,
please? Maybe I find the time to have a go.
Regards
H
Hi Heinrich,
I have LO 3.3 installed on Windows/Vista and Linux-Mint-Lisa. The native
MySQL-Connector
worked flawlessly - at least for what I use it. As a "fall-back" I still
use the Vista-
System. But, when going to 3.5.0-RC2 today, I saw that - as I had
already noticed earlier
on, the connector cannot be activated. ODBC works - well, kind of!
Is your Linux Mint 64bit or 32bit ?
If it is 32bit, then try the Linux connector here :
http://extensions.libreoffice.org/
but it seems to be down at the moment or not responding (overloaded ??)
It is better to remove the old connector from your 3.5 configuration
first (if it was either copied over automatically or you installed it
yourself).
I have never built anything from source in LO. Could you point me in the
right direction,
please? Maybe I find the time to have a go.
If you have a 64bit Mint then you will need a 64bit connector which
means compiling from scratch.
The same goes for Windows, except you will also need to download the
mysql C connector library (32bit) from the mysql web site and put it
somewhere where the local git repository for the LO source code can
acess it.
The best place to start is the Developer wiki page :
http://www.libreoffice.org/get-involved/developers/
This will get you started with the basic setup of your development
environment. You can not build the mysql connector without having the
complete LO source as a local git repository on the machine that does
the building.
My personal experience was one of pain on MacOSX, and it still gets
broken rather easily on that, and yet one of ease on Linux, which is
hardly surprising since that is the OS of choice for most of the
developers involved in the project.
Alex
Hi Heinrich,
I have LO 3.3 installed on Windows/Vista and Linux-Mint-Lisa. The native
MySQL-Connector
worked flawlessly - at least for what I use it. As a "fall-back" I still
use the Vista-
System. But, when going to 3.5.0-RC2 today, I saw that - as I had
already noticed earlier
on, the connector cannot be activated. ODBC works - well, kind of!
The old connector has been reported as working again on Windows with
3.5RC2, see the bug report :
https://bugs.freedesktop.org/show_bug.cgi?id=44075
Alex
Hi Ian
Sorry but I need to catch up.
This is a 650Meg file using the embedded db engine, right.
The file is usable on other machines, but not on the Mint based machine
you need it on and this stopped working after the most recent update of
the OS (to version 12) - do I have that correct?
If so one quick question - can you run any other Base files using an
embedded db on that machine, since the upgrade?
Thanks
//drew
Actually one more - Do you have skype?
Hi Drew
Thanks for the reply.
I originally developed my DB in OO about 6 years back and have been using it in OO since then. I've always used the embedded engine. When LO 'forked' away from OO I tried that but could never get my Database to run - it would just crash Base whereas it was still working in OO. As each version of LO came out I gave it another try always with the same results. About a month or two back with some suggestions from the Forum I moved my DB to LO and re-developed my front-end Form and it worked!! But I ran into another problem which escapes me right now so moved back to OO.
With my latest upgrade to Mint 12 KDE I had a problem that LO would not even start. So I installed OO again and it ran OK BUT I had problems with it not saving data. So I removed OO and re-installed LO (from the LO WebSite) and this is where I sit now with the "No SDBC driver found" error.
I have no other DB to try but yesterday I found an old backup of my Database from about a year ago and tried to open that and got the same SDBC error. I can however create a new database in LO with no problems. My file is 640Mb in size and if I look at it with an un-zip program I can "see" all the contents.
Yes - I am on skype - 'ianzs6cdx' (But only Keyboard-to-Keyboard as I have not had a chance to get my microphone working in Mint 12 yet!!)
Thanks a lot.
Hi
Excellent work Alex! It is really good to know people are keeping an eye on this sort of thing. It's also good to know that an old system suddenly works again.
Thanks and regards from
Tom