Hi Landon, Thanks for the link. I'll look into installing the JDBC connector for OO after I get my database populated w/data :)
Interestingly, I'm on a Mac OSX and the README for OO 1.1.2 for that platform mentioned that only
the ODBC/JDBC bridge connector was supported, not native ODBC functionality. I have installed MyODBC and
iODBC and have successfully connected to MySQL via database types = ODBC and MySQL.
The only database that OO can see currently is the "test" database MySQL comes with.
Haven't had time to begin looking at the OO source yet to see what is going on. I started with a binary
distribution.
Am I to understand that OO is limited to connecting to one database server at a time ? Or just database
from a given server ? I'd like to be able to use OO while connecting to a MySQL server on one machine
and a Sybase server on another machine.
Ed
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,> >my MySQL database. I could then access and manipulate that data from
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>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]
-- E. J. Mansky II Eikonal Research Institute Bend, OR.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
