Re: [gentoo-user] Open Office and ODBC Connection to MySQL

[Antoine]

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@g.o mailing list