Accessing MySQL with OpenOffice - 07-19-2004 , 02:53 PM
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:mysqldbc" 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