You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by BL- Entertainment <BL...@hotmail.com> on 2016/08/24 16:47:57 UTC

Problem with Address Book Data Source Wizard

Hello,

In Open off I went under File to Wizard and then Address Data Source. I selected Thunderbird and clicked next but instead of going forward I received the following error message:

"The connection to the external data source could not be established. No SDBC driver was found for the given URL."

Then I click on more and get the following:
"SQL Status: HY000
The connection to the external data source could not be established. No SDBC driver was found for the given URL."
"A connection for the following URL was requested "sdbc:address:thunderbird"."

Can you please tell me how to fix this? Are is there a different way I can use my contact list to create mailing labels?

Please help,
Sherl

Re: Problem with Address Book Data Source Wizard

Posted by "Keith N. McKenna" <ke...@comcast.net>.
BL- Entertainment wrote:
> Hello,
> 
> In Open off I went under File to Wizard and then Address Data Source.
> I selected Thunderbird and clicked next but instead of going forward
> I received the following error message:
> 
> "The connection to the external data source could not be established.
> No SDBC driver was found for the given URL."
> 
> Then I click on more and get the following: "SQL Status: HY000 The
> connection to the external data source could not be established. No
> SDBC driver was found for the given URL." "A connection for the
> following URL was requested "sdbc:address:thunderbird"."
> 
> Can you please tell me how to fix this? Are is there a different way
> I can use my contact list to create mailing labels?
> 
> Please help, Sherl
> 
Sherl;
Direct access was removed in Version 4.1 as explained in the section of
the Version 4.1.0 Release Notes at the following link:
<https://cwiki.apache.org/confluence/display/OOOUSERS/AOO+4.1+Release+Notes#AOO4.1ReleaseNotes-SeamonkeyreplacedbyNSS%28%22NetworkSecurityServices%22%29>.
You can use Thunderbird's export facilities to create a csv file that
can then be imported into an AOO database for use as a data source for
your mailing labels by following the below.

1: Open your Thunderbird Address Book
2: Select the Address book you want to export
3: click Tools->Export
4: A window will open asking where and in what format to export to:
	a)Save the file with a name and in a location easy for you to
 	remember as a comma separated (csv) file.
5: Close the Thunderbird address book window.
6: Open AOO
7: Click File->Wizards>Address Data Source..
	a) Select Other external data source
	b) Click Next
	c) Click Setting's button
	d) Select Test from the drop down list
	e) Click Next
	f) Click Browse button
		1. Browse to the location you exported the file in step
		   3
	g) Click Next
	h) Select comma separated value files
	i) Click Finish
	j) Click Field Assignment Button
	k) Use the Drop down lists to map the fields in the data base
 	   to the fields in the csv file
	l) The last screen will present a default location and name for
	   new database.
		a) Click finish to accept defaults
		b) Change them
	m) Click Finish
The database is now ready to be used as a data source to create your
mailing labels.

As a courtesy I have cc'd your e-mail address as you are not subscribed
to the mailing list. Please reply only to the list and not my e-mail.

Regards
Keith