469,934 Members | 1,869 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

Accessing MySQL with OpenOffice

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
0 1432

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Brandon | last post: by
15 posts views Thread by B. Pigman | last post: by
reply views Thread by Bob M | last post: by
reply views Thread by Jean-Marie Gouarné | last post: by
7 posts views Thread by phillip.s.powell | last post: by
7 posts views Thread by PaoloB | last post: by
5 posts views Thread by Vik Rubenfeld | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.