Issue 124987

Summary: Configuring address books fails with "SDBC driver for URL not found"
Product: Base Reporter: jotielmann
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: damjan, frank.schoenheit, g, gdwolf, majoc, mattdeany.wright, mseidel, oooforum
Version: 4.1.0   
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
See Also: https://bz.apache.org/ooo/show_bug.cgi?id=124183
Issue Type: DEFECT Latest Confirmation in: 4.2.0-dev
Developer Difficulty: ---

Description jotielmann 2014-05-26 15:47:39 UTC
in version 4.1.0 it is not possible to access to the thunderbird adress-book.
error message: HY000 SDBC driver for URL not found.

In version 4.0.1 it works with the same SDBC-Drivers in the repository.

See attachment.

I am going back to version 4.0.1
Comment 1 Ariel Constenla-Haile 2014-05-26 15:53:09 UTC
This functionality has been removed, it is documented in the release notes

https://cwiki.apache.org/confluence/display/OOOUSERS/AOO+4.1+Release+Notes#AOO4.1ReleaseNotes-SeamonkeyreplacedbyNSS%28%22NetworkSecurityServices%22%29

It should be documented under "Removed/Retired Features"...
Comment 2 mroe 2014-05-26 16:12:16 UTC
*** Issue 124988 has been marked as a duplicate of this issue. ***
Comment 3 Graham Horner 2014-08-10 17:31:06 UTC
*** Issue 125397 has been marked as a duplicate of this issue. ***
Comment 4 Graham Horner 2014-08-10 17:42:10 UTC
No, it's documented under "Improvements"!

Support for _any_ proprietary address books and LDAP seems to have been removed. Remarkable in a package designed to do mail merge.

Can we expect this support to be restored soon?  If not, at least can the documentation be updated and the Address Data Source Wizard be removed to avoid confusion?
Comment 5 georgewolf 2014-08-11 16:01:55 UTC
This is a very important issue for me, and I miss the integration greatly.
Comment 6 Ariel Constenla-Haile 2014-08-18 02:30:14 UTC
For the documentation, see Issue 124186
For the Address Data Source Wizard, see Issue 124183
Comment 7 mattdeany 2015-04-10 09:17:50 UTC
I would dearly like to see address book access reestablished, especially for Thunderbird. The combination of Mozilla and Open Office has been cheap(free!), and sane and consistent for me over many years and now I need to access my address book (new business, mail contacts, invoices, etc) I can not. Disappointing.
Comment 8 jotielmann 2015-04-10 10:15:49 UTC
Since OpenOffice 4.1.0 there is no access to the database of  the thunderbird address book.
But it is possible to export the thunderbird address book to a *.csv-file and read this file using OpenOffice Calc.
Comment 9 mattdeany 2015-04-10 10:25:09 UTC
(In reply to jotielmann from comment #8)
> Since OpenOffice 4.1.0 there is no access to the database of  the
> thunderbird address book.
> But it is possible to export the thunderbird address book to a *.csv-file
> and read this file using OpenOffice Calc.

Thank you. However, I was about to contruct a database of clients and invoicing functions via Base, integrated with Thunderbird. It would be good if this functionality were still there.
Thank you again for the .csv comment. Good to know. But better if there was integration.
Matt
Comment 10 Jochen 2016-02-11 20:56:52 UTC
Together with LibreOffice 5.0.4 it works fine. Due to the change in OpenOffice I was urged to go for LO. The client of mine is not able to work via CSV files (technical not that experienced). I would appreciate if AOO could implement this interface again.
Comment 11 oooforum (fr) 2018-08-09 09:30:27 UTC
(In reply to Jochen from comment #10)
> I would appreciate if AOO could implement this interface again.
Help for LDAP/SDBC driver development is welcome:
https://wiki.openoffice.org/wiki/Base_To-Do/SDBC_driver_for_LDAP_directories
Comment 12 oooforum (fr) 2019-04-27 21:40:58 UTC
*** Issue 17619 has been marked as a duplicate of this issue. ***