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]
