C. Beamer wrote:
Hi all,
I'm tearing my hair out by the roots on this one.
First, I had a bit of a problem getting the the ODBC connection to my
MySQL database set up. That was my own fault though 'cause a couple of
files that I though were supposed to go in /etc (that's where they went
in Fedora Core) were actually supposed to go in /etc/unixODBC/.
So, I got the connection set up okay.
The issue that I'm having is that once I got the ODBC connection
working, I can view the data source in Open Office, but cannot edit the
table. I took a look on Gentoo Forums and I found one similar issue
except that it turned out that the person did not have a primary key
set. I have a primary key set in the MySQL database, but I still can't
edit the table in Open Office.
...
Any ideas?
Alas yes - I think this is probably an OO problem. Have a look on the OO
bugzilla - you will find at least one other DB (Oracle 9i and 10) that
doesn't work with ODBC (though this is under doze). Several of us have
not been able to get odbc connections working properly (i.e., read but
no edit) that work fine in microsoft products...
Cheers
Antoine
--
gentoo-user@gentoo.org mailing list
