Posted: Mon Aug 23, 2004 12:49 am Post subject: MySQL/OO setup
I'm hoping to be teaching British curriculum ICT in the next couple of weeks and would really like to use Open Office. The major stumbling block at the moment is getting the Database aspect of the course covered. I'm sure this is possible using OpenOffice/MySQL/Panther combination, but have not been able to locate simple, but comprehensive setup instructions.
Posted: Thu Nov 25, 2004 3:49 am Post subject: Re: MySQL/OO setup
oldgit wrote:
I'm hoping to be teaching British curriculum ICT in the next couple of weeks and would really like to use Open Office. The major stumbling block at the moment is getting the Database aspect of the course covered. I'm sure this is possible using OpenOffice/MySQL/Panther combination, but have not been able to locate simple, but comprehensive setup instructions.
Any offers... please?
Well I guess you started teaching your course without OOo I too am looking for detailed instructions on how to setup a database connection between OOo X11 for Mac and mysql.
From what I have gathered thus far, you can forget ODBC. There simply aren't any mysql odbc drivers at the moment. You can download a set of resource files from the mysql web site that you are supposed to be able to compile and run on MacOSX, but that is not an alternative I can go for, knowing next to nothing about MacOSX and little more about compiling.
There is also the JDBC alternative. I saw from previous discussions on one of these lists that it is possible to connect to a mysql db from OOo X11, but unfortunately no instructions were given. All I need to know is where to copy the jar file (at the moment I've put it in the JVM Extensions folder), and which parameters to put in the command line. THe rest I can probably deal with from the other documentation available on the OpenOffice.org website.
Joined: May 31, 2003 Posts: 219 Location: French Alps
Posted: Thu Nov 25, 2004 1:53 pm Post subject: MySQL setup
Donwload Connector/J from MySQL main site.
The inclued README gives many information.
The most important keypoints are:
• the class name of the JDBCdriver: com.mysql.jdbc.Driver
• the URL format: jdbc:mysql://host.domain/database_name
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 "<NeoOffice>/Contents/MacOS/classes" folder to get it found. Didn't check with recent release if the previous classpath setting does work.
With this basic setup the connection should works.
Then you come to the fine tuning stuff: charset, etc...
Posted: Fri Nov 26, 2004 11:05 pm Post subject: Re: MySQL setup
Max,
Max_Barel wrote:
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 "<NeoOffice>/Contents/MacOS/classes" 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. After adding the jar file in that pane and restarting Neo/J, I successfully connected to my MySQL database.
Joined: May 31, 2003 Posts: 219 Location: French Alps
Posted: Sun Nov 28, 2004 5:52 pm Post subject: Re: MySQL setup
pluby wrote:
Max,
FYI. I just tried adding the MySQL jar file using the Security pane in the Tools->Options menu item Neo/J. After adding the jar file in that pane and restarting Neo/J, I successfully connected to my MySQL database.
Confirmed.
I can't remember when, nor with which version, my first attempt to do it this way failed.
Max
Pick either binary or source. I downloaded and installed from source. Version 3.51.10 is the latest and correctly creates bundled libraries needed for OSX.
I run Mac OSX 10.2.8 and gcc 3.3 in the Aug 03 Developer CD.
Second, there are a number of links with details on using MySQL w/OO.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum