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

2005-10-19 Thread 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@gentoo.org mailing list

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

2005-10-18 Thread C. Beamer 
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.

I have no idea what to try next.  I'm using the ebuild
openoffice-bin-1.1.5.  However, I tried the openoffice-ximian ebuild and
had no better luck with that.

I don't think its a permission problem 'cause I checked this and I am a
member of the mysql group.

Any ideas?

Regards,

Colleen
-- 
gentoo-user@gentoo.org mailing list