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.

Contents

1 MySQL driver page 1
1.1 The driver page in detail 1
1.2 String List 1

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 MyODBC1 data source which must be defined in the used system. The second kind is to use the JDBC2 version from MySQL named “connector/J”.

1.1 The driver page in detail

Rahmen1
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 inserted3. 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.



1Open database connectivity

2Java database connectivity

3The driver class will be searched for in the jar files which can be added under tools->options->Security.