Revision as of 14:08, 13 February 2005 (edit) Sardisson (Talk | contribs) m ← Previous diff |
Current revision (03:20, 12 February 2008) (edit) (undo) Sardisson (Talk | contribs) m |
(3 intermediate revisions not shown.) |
Line 1: |
Line 1: |
- | = This page is obsolete = | + | #REDIRECT [[NeoBase]] |
- | | + | |
- | Somehow it didn't get moved or updated properly; the current page is [[Using_MySQL|Using_MySQL]] | + | |
- | | + | |
- | | + | |
- | == Enabling NeoOffice/J or OpenOffice.org/X11 to connect to MySQL databases == | + | |
- | | + | |
- | * Download Connector/J from the [http://www.mysql.com/products/connector/ MySQL website]. | + | |
- | ** The included README gives much information. | + | |
- | ** The most important keypoints are: | + | |
- | *** the class name of the JDBCdriver: <tt>com.mysql.jdbc.Driver</tt> | + | |
- | *** the URL format: <tt>jdbc:mysql://host.domain/database_name</tt> | + | |
- | ** You will need a version of Connector/J that supports Java 1.3.x, since that is the version of Java used in NeoOffice/J. | + | |
- | | + | |
- | *The jar file location: | + | |
- | ** for OOo/X11: you can put it where you want. To let OOo know, you shoud go to "Tools->Options" menu item. Then in the "security" pane, there is a place to add directories to classpath. Click on browse and find your jar file. | + | |
- | ** for Neo/J: I had to put it in the <tt><NeoOffice>/Contents/MacOS/classes</tt> folder to get it found. Didn't check with recent release if the previous classpath setting does work. | + | |
- | *** FYI. I just tried adding the MySQL jar file using the Security pane in the Tools->Options menu item Neo/J 1.1 Alpha 2. After adding the jar file in that pane and restarting Neo/J, I successfully connected to my MySQL database. | + | |
- | | + | |
- | With this basic setup the connection should work. | + | |
- | | + | |
- | Then you come to the fine tuning stuff: charset, etc... | + | |
- | | + | |
- | ''There is also an attachment (.sxw) to [http://www.openoffice.org/issues/show_bug.cgi?id=13753 OpenOffice.org Issue 13753] which contains screenshots and a different location for placing the Connector/J file.'' | + | |
- | | + | |
- | There are additional pointers available in [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=1004 this thread on trinity] on other MySQL configuration issues. | + | |