1. Create a writer document, say MailMergeTest.odt. 2. File > Wizards > Address Data Source. 3. There is only one choice for address book type for my operating system: Other external data source. Choose it. 4. Click Next>> An error dialog reading "The connection to the external data source could not be established. No SDBC driver was found for the given URL. 5. Click More The error dialog that appears reads says that this is "SQL Status: HY000". 6. OK 7. OK 8. Cancel The expectation is that Next>> will allow us to advance to do "Connection Settings" and define the database type as "Spreadsheet".
I can confirm this bug on Linux Mint 12 x86_64 and Gentoo Linux x86_64 (Libreoffice 3.4.3) (Java useflag disabled). I get exactly the behavior described here. On both systems. If it was only on Gentoo, I would have thought it was because of my useflags. But I've seen it on Linux Mint too. There seems to be a similar problem in Ubuntu 32bit: http://lists.freedesktop.org/archives/libreoffice-bugs/2011-December/027978.html
So I reemerge (or upgraded) LibreOffice 3.4 to 3.4.5, now with Java useflag enabled. Same effect. I'm using Sun Java 1.6.
reproduced in 3.6.0 master on Fedora 64 bit but not reproduced in 3.3.4, therefore regression
@ Lionel Please, take look at this
When you get the "No SDBC driver was found for the given URL" error message, please click "more". In the left part of the window (error list), you should have two entries. The second entry says something along the lines of: "A connection for the following URL was requested "sdbc:XXXXX". What comes instead of the XXX for you? Since it works in 3.3.4, what are the steps in the wizard called in 3.3.4? I get (in 3.5): Address Book Type Table Selection Field Assignment Data Source Type Frpom the descroption, I get the impression that there should be an extra step?
Hmm... I get the same problem for *any* choice in step 1. Do any of the other choices (LDAP, Mozilla, Thunderbird, ...) work for anybody with LibO 3.4 or 3.5?
In 3.6.0 master in only one choice: Other external data sources Error text: SQL Status: HY000 The connection to the external data source could not be established. No SDBC driver was found for the given URL. Information text: A connection for the following URL was requested "sdbc:address:evolution:local".
3.5.0 rc 3 has choices: Mozilla/Thunderbird/LDAP/Other If select Other, appears the same problem
(In reply to comment #8) > 3.5.0 rc 3 has choices: Mozilla/Thunderbird/LDAP/Other > If select Other, appears the same problem And if you select "LDAP" or "Thunderbird" or "Mozilla"?
In 3.5.0 the same problem with Mozilla/Thunderbird/LDAP but my be so should be with Mozilla/Thunderbird/LDAP in 3.3.4 they propose select some file
OK, then the problem is wider than current summary. Correcting summary. Basically, independently of any choice one makes in step 1, it always tries to get data from evolution instead of from the source chosen.
Fixed in master: http://cgit.freedesktop.org/libreoffice/core/commit/?id=8eb33ee13519bd3059cdb2019ef843fbb9a7fbd7 For 3.5.1 and 3.4.6, pending review.
Thanks
patch was pushed to libreoffice-3-5 and libreoffice-3-4