Project tools

Project home

Membership

Announcements

Mailing lists

Documents & files

Version control

Issue tracker

OpenOffice.org Base

Specifications

QA

Development

Developer projects

Project Structure

Database Drivers

PostgreSQL

MDB

SQLite

Search

This project All projects

Advanced search

Google search

How do I...

• Sitemap
• FAQ
• Get help?

start:

MySQL driver page

applies to StarOffice 6.1
status: finished, last modified: 22. Nov. 2002

Version History

11/10/02		Ocke Janssen	first draft
11/21/02		Elizabeth Matthis	GUI string review

Abstract

To create a new data source with the new MySQL driver, the data source administration dialog must be extended. A new page will be inserted where the user can fill in all necessary information which are needed to connect to a MySQL database.



1 MySQL driver page

The new driver page fort MySQL allows the user to select between two different kinds of 'how to connect to the MySQL database'. The first possibility is to use an existing MyODBC¹ data source which must be defined in the used system. The second kind is to use the JDBC² version from MySQL named “connector/J”.

1.1 The driver page in detail

In the first group box the user can select which kind of connection he would like to use. Either an existing ODBC data source which must be defined in the used system or to connect to the database via the JDBC interface. To allow the user to specify different driver classes, an extra edit field is enabled when the JDBC was selected, where the name of the driver class can be inserted³. In the second group box information about the data source, the user name, if a password is required and which character set the MySQL server should use, can be defined. The URL field contains different meaning depending on the type of connection. In the case of ODBC, it contains the name of the ODBC data source; in the case of JDBC it contains the host name, a port number and the database name. To give the user a hint, the URL field will contain a default value for a JDBC kind of connection, where the user has to substitute only the fields in the brackets.

1.2 String List

String	German translation	comment
Type of connection	Art der Verbindung	Fixed line; Separates the kind of connection from the general information. No mnemonic necessary.
Use existing My~ODBC data source	Existierende My~ODBC Datenquelle verwenden	Radio button label; Will be marked by the user when he wants to use an existing ODBC system data source. “MyODBC” is product name and not to translate.
Use Connector/~J3	Connector/~J3 verwenden	Radio button label; Connector/J3 is the JDBC driver from MySQL. Do not translate or change “Connector/J3”-- it is a product name.
MySQL JDBC d~river class	MySQL JDBC ~Treiberklasse	The label for the edit (text box), where the user can insert the JDBC driver class for MySQL
General	Allgemein	Fixed line; A separator. No mnemonic necessary.
~Data source URL	D~atenquellen-URL	Text box label; The url for the connection.
~User name	~Benutzername	Text box label; The user name needed to connect to the database.
Password r~equired	Kennwort ~erforderlich	Check box label; Indicates that a password is needed to connect to the database.
~Character set	~Zeichensatz	Text box label; The character set.
<host>:<3306>/<DBNAME>	<Rechnername>:<3306>/<DBNAME>	String; will be inserted into the URL field when choosing the Connector/J3 to give the user a clue about what is needed.
	General Page
To adjust the settings, go to the MySQL tab page.	Wechseln Sie zur MySQL-Registerseite um die Einstellungen vorzunehmen.	This text will be shown on the general page when the type MySQL is selected.