Ed, I am using the JDBC driver ConenctorJ to connect to MySQL from OpenOffice. I hope to put together some documentation on this porcess for other users soon. In fact, I'm preparing a slide presentation for the Desktop Linux Conference in San Diego that explains how to do this.
If you want to try it without my doc, you can download ConnecotrJ from here: http://dev.mysql.com/downloads/connector/j/3.0.html You need to have java enabled in OO, and have a JRE on your machine. Go to tools>options and then add the jar file for ConnectorJ to your path using the "add archive" button. Restart OO and then go to File>New>Database. Walk your way through the wizards. You can use JDBC as the database type, or MySQL. I recommend MySQL. Your MySQL database needs to be created before you can connect. As far as I know you can't create a new MySQL database in OO. I haven't messed with the ODBC drivers yet. When I finish my JDBC/MYSQL/OO doc, I'll have to check that out. I only have a user and password set up for the entire MySQL database that I connect to in OO. I do need both to connect to the database. I haven't experimented with table security restrictions yet. Landon On Mon, 31 Jan 2005 09:56:03 -0800, Ed Mansky <[EMAIL PROTECTED]> wrote: > Landon, > I have a related question. How did you get OO to connect to your MySQL > (non-test) database ? I have finally got all the pieces to work with MySQL/OO > but I am only able to view/edit the "test" database in MySQL. > > In OO I tell it to use the System-wide DSN "MySQL-test", for which I have > an > entry in odbc.ini. One entry in the "MySQL-test" driver for "Database" which > I've set equal to my new MySQL database. The second entry is for "Driver" > which > is equal to "MySQL". If I understand ODBC, that "MySQL" driver entry > in "MySQL-test" > points to the odbcinst.ini entry for driver "MySQL" which in turn has > entries for the > actual driver and setup libraries (full paths and names). This > odbcinst.ini entry is > how ODBC and hence MyODBC knows which libraries to load dynamically. > Is this sequence correct ? > > Also, what kind of permissions do you set in user and db tables in > database "mysql" to handle > logins from the user specified in the odbc.ini driver entry OO is > told to load ? > > I've gotten my Perl scripts to connect and use my new database fine, > just OO and NeoOffice > can't see to "see" the new database yet. > > Ed > > >Chris, > > > >I'm not sure I understand your question exactly, but I'm going to take > >a stab at a reply. First of all, with the latest development versio of > >OpenOffice, you connect to an existing database, or use the embedded > >HSQL database. AS far as I know, connections to multiple databases in > >one .odb docuement is not allowed. The trick is to get the data into > >your database using it's import functions, and then access that > >database with OpenOffice. For example, I'm using MySQL and OpenOffice. > >If I have data in 3 CSV files that I want to access in OpenOffice, I > >would use the MySQL command interface to import those CSV files into > >my MySQL database. I could then access and manipulate that data from > >an OpenOffice .odb document connected to that MySQL database. > > > >Some others on this list may have another solution. > > > >Let me know if you have other questions, and I'll try my best to help. > > Remember, I'm still learning this too. :] ) > > > >Landon > > > >On Sat, 29 Jan 2005 16:37:55 +0000, Chris Green <[EMAIL PROTECTED]> wrote: > >> How can one add a new 'external' datasource to Database? > >> > >> In Writer and Calc the View menu has a Datasource entry where one can > >> do this but the View menu isn't similarly expanded in Database. > >> > >> -- > >> Chris Green ([EMAIL PROTECTED]) > >> > >> "Never ascribe to malice that which can be explained by incompetence." > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > >> > >> > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > -- > E. J. Mansky II > Eikonal Research Institute > Bend, OR. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
