| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> |
| <HTML> |
| <head> |
| <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252"> |
| <TITLE>MySQL driver page</TITLE> |
| <META NAME="GENERATOR" CONTENT="StarOffice 6.0 (Win32)"> |
| <META NAME="AUTHOR" CONTENT="Ocke Janssen"> |
| <META NAME="CREATED" CONTENT="20020306;7403200"> |
| <META NAME="CHANGEDBY" CONTENT="Ocke Janssen"> |
| <META NAME="CHANGED" CONTENT="20021122;10010893"> |
| </head> |
| <body LANG="en-US" LINK="#0000cc"> |
| <P ALIGN=CENTER><FONT FACE="Albany"><FONT SIZE=5><B>MySQL driver page</B></FONT></FONT></P> |
| <P ALIGN=CENTER><FONT FACE="Albany"><FONT SIZE=3><I><SPAN LANG="en-US">applies</SPAN> |
| to StarOffice 6.1 <BR>status: finished, last modified: <SDFIELD TYPE=DOCINFO SUBTYPE=CHANGE FORMAT=DATE SDNUM="1033;1033;D. MMM. YYYY">22. Nov. 2002</SDFIELD></I></FONT></FONT></P> |
| <H1><FONT FACE="Albany"><FONT SIZE=4>Version History</FONT></FONT></H1> |
| <TABLE WIDTH=586 BORDER=1 CELLPADDING=4 CELLSPACING=0 FRAME=HSIDES RULES=ROWS> |
| <COL WIDTH=99> |
| <COL WIDTH=32> |
| <COL WIDTH=129> |
| <COL WIDTH=294> |
| <THEAD> |
| <TR> |
| <TD WIDTH=99 VALIGN=BOTTOM SDVAL="37570" SDNUM="1033;0;MM/DD/YY"> |
| <P ALIGN=RIGHT><FONT FACE="Albany"><FONT SIZE=2>11/10/02</FONT></FONT></TD> |
| <TD WIDTH=32 VALIGN=TOP> |
| <P ALIGN=LEFT><BR> |
| </TD> |
| <TD WIDTH=129 VALIGN=TOP> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Ocke Janssen</FONT></FONT></TD> |
| <TD WIDTH=294 VALIGN=TOP> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>first draft</FONT></FONT></TD> |
| </TR> |
| </THEAD> |
| <TBODY> |
| <TR> |
| <TD WIDTH=99 VALIGN=BOTTOM SDVAL="37581" SDNUM="1033;0;MM/DD/YY"> |
| <P ALIGN=RIGHT><FONT FACE="Albany"><FONT SIZE=2>11/21/02</FONT></FONT></TD> |
| <TD WIDTH=32 VALIGN=TOP> |
| <P ALIGN=LEFT><BR> |
| </TD> |
| <TD WIDTH=129 VALIGN=TOP> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Elizabeth Matthis</FONT></FONT></TD> |
| <TD WIDTH=294 VALIGN=TOP> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>GUI string review</FONT></FONT></TD> |
| </TR> |
| </TBODY> |
| </TABLE> |
| <H1><FONT FACE="Albany"><FONT SIZE=4>Abstract</FONT></FONT></H1> |
| <P ALIGN=JUSTIFY><FONT FACE="Thorndale">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.</FONT></P> |
| <DIV ID="Table of Contents1"> |
| <DIV ID="Table of Contents1_Head"> |
| <H1><FONT FACE="Albany"><FONT SIZE=4>Contents</FONT></FONT></H1> |
| </DIV> |
| <DL> |
| <DT><FONT FACE="Albany"><FONT SIZE=2>1 MySQL driver page 1</FONT></FONT><DT> |
| <FONT FACE="Albany"><FONT SIZE=2>1.1 The driver page in detail 1</FONT></FONT><DT> |
| <FONT FACE="Albany"><FONT SIZE=2>1.2 String List 1</FONT></FONT></DL> |
| </DIV> |
| <H1><FONT FACE="Albany"><FONT SIZE=4>1 MySQL driver page</FONT></FONT></H1> |
| <P ALIGN=JUSTIFY><FONT FACE="Thorndale">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<A CLASS="sdfootnoteanc" NAME="sdfootnote1anc" HREF="#sdfootnote1sym"><SUP>1</SUP></A> |
| data source which must be defined in the used system. The second kind |
| is to use the JDBC<A CLASS="sdfootnoteanc" NAME="sdfootnote2anc" HREF="#sdfootnote2sym"><SUP>2</SUP></A> |
| version from MySQL named “connector/J”. </FONT> |
| </P> |
| <H2><FONT FACE="Albany"><FONT SIZE=4>1.1 The driver page in detail</FONT></FONT></H2> |
| <P ALIGN=JUSTIFY><IMG SRC="./MySQL_data_source_page_html_17ee6536.gif" NAME="Rahmen1" ALT="Rahmen1" ALIGN=LEFT HSPACE=8 VSPACE=8><BR CLEAR=LEFT><FONT FACE="Thorndale">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<A CLASS="sdfootnoteanc" NAME="sdfootnote3anc" HREF="#sdfootnote3sym"><SUP>3</SUP></A>. |
| 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.</FONT></P> |
| <H2><FONT FACE="Albany"><FONT SIZE=4>1.2 String List</FONT></FONT></H2> |
| <TABLE WIDTH=100% BORDER=1 CELLPADDING=4 CELLSPACING=0> |
| <COL WIDTH=85*> |
| <COL WIDTH=85*> |
| <COL WIDTH=85*> |
| <THEAD> |
| <TR VALIGN=TOP> |
| <TH WIDTH=33%> |
| <P><FONT FACE="Albany"><FONT SIZE=2>String</FONT></FONT></TH> |
| <TH WIDTH=33%> |
| <P><FONT FACE="Albany"><FONT SIZE=2>German translation</FONT></FONT></TH> |
| <TH WIDTH=33%> |
| <P><FONT FACE="Albany"><FONT SIZE=2>comment</FONT></FONT></TH> |
| </TR> |
| </THEAD> |
| <TBODY> |
| <TR VALIGN=TOP> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Type of connection</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P><FONT FACE="Albany"><FONT SIZE=2>Art der Verbindung</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Fixed line; |
| Separates the kind of connection from the general information. No |
| mnemonic necessary.</FONT></FONT></TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Use existing |
| My~ODBC data source</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P><FONT FACE="Albany"><FONT SIZE=2>Existierende My~ODBC |
| Datenquelle verwenden</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>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.</FONT></FONT></TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Use Connector/~J3</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Connector/~J3 |
| verwenden</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Radio button |
| label; Connector/J3 is the JDBC driver from MySQL. Do not |
| translate or change “Connector/J3”-- it is a product |
| name.</FONT></FONT></TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>MySQL JDBC d~river |
| class</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>MySQL JDBC |
| ~Treiberklasse</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>The label for the |
| edit (text box), where the user can insert the JDBC driver class |
| for MySQL</FONT></FONT></TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>General</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Allgemein</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Fixed line; A |
| separator. No mnemonic necessary.</FONT></FONT></TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>~Data source URL</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>D~atenquellen-URL</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Text box label; |
| The url for the connection.</FONT></FONT></TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>~User name</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>~Benutzername</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Text box label; |
| The user name needed to connect to the database.</FONT></FONT></TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Password r~equired</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Kennwort |
| ~erforderlich</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Check box label; |
| Indicates that a password is needed to connect to the database.</FONT></FONT></TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>~Character set</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>~Zeichensatz</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Text box label; |
| The character set.</FONT></FONT></TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2><host>:<3306>/<DBNAME></FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2><Rechnername>:<3306>/<DBNAME></FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>String; will be |
| inserted into the URL field when choosing the Connector/J3 to |
| give the user a clue about what is needed.</FONT></FONT></TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TH WIDTH=33%> |
| <P><BR> |
| </TH> |
| <TH WIDTH=33%> |
| <P><FONT FACE="Albany"><FONT SIZE=2>General Page</FONT></FONT></TH> |
| <TH WIDTH=33%> |
| <P><BR> |
| </TH> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>To adjust the |
| settings, go to the MySQL tab page.</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Wechseln Sie zur |
| MySQL-Registerseite um die Einstellungen vorzunehmen.</FONT></FONT></TD> |
| <TD WIDTH=33%> |
| <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>This text will be |
| shown on the general page when the type MySQL is selected.</FONT></FONT></TD> |
| </TR> |
| </TBODY> |
| </TABLE> |
| <P ALIGN=JUSTIFY><BR><BR> |
| </P> |
| <DIV ID="sdfootnote1"> |
| <P><FONT FACE="Thorndale"><FONT SIZE=2><A CLASS="sdfootnotesym" NAME="sdfootnote1sym" HREF="#sdfootnote1anc">1</A>Open |
| database connectivity</FONT></FONT></DIV> |
| <DIV ID="sdfootnote2"> |
| <P><FONT FACE="Thorndale"><FONT SIZE=2><A CLASS="sdfootnotesym" NAME="sdfootnote2sym" HREF="#sdfootnote2anc">2</A>Java |
| database connectivity</FONT></FONT></DIV> |
| <DIV ID="sdfootnote3"> |
| <P><FONT FACE="Thorndale"><FONT SIZE=2><A CLASS="sdfootnotesym" NAME="sdfootnote3sym" HREF="#sdfootnote3anc">3</A>The |
| driver class will be searched for in the jar files which can be |
| added under tools->options->Security.</FONT></FONT></DIV> |
| </body> |
| </HTML> |