By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,384 Members | 845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,384 IT Pros & Developers. It's quick & easy.

Accessing MySQL with OpenOffice

P: n/a
This question is about MySQL and how it can be accessed with OpenOffice
(presumably the same issue would arise with MS Office, but I'm not sure
about that). The problem I'm having is with the setup in OpenOffice.

The database currently consists of a single table, located in
c:\MySQL\data. The database is CD_Collection; the table name is Album.
There is no password associated with the database/table. (I'm just
getting started, and wanted to keep it as simple as possible; I'll add
the controls later.)

OpenOffice is version 1.1.2

I'd like to be able to open a text file, and import or link the document
to the database.

In the Data Source Administration window:

- At the General tab, I've changed the Database type to MYSQL.

- at the MYSQL tab, I'm not sure which Type of Connection to check, so
I've tried both "Use existing MyODBC data source" and "Use connector /J3
MYSQL JDBC driver class"

- Under General (still at the MYSQL tab), the Data Source URL shows up
as either "sdbc:mysql:odbc" or "sdbc:mysql:jdbc" depending on which Type
of Connection I check, but I'm not sure what else should appear on the
line (that I should type). I have typed in <localhost>:<3306> and a path
to the database, but I still get the same error as follows when I move
to the Tables tab

- when I click on the Tables tab, I get the following error:

"No connection could be established for the URL
sdbc:mysql:jdbc:<localhost>:<3306>" then the path I've typed.

I'm quite sure the information I've typed in the Data Source URL line is
the problem, but none of the examples in OpenOffice Help lead me to a
solution.

Any ideas?

Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.