On Wednesday 30 March 2005 13:25, Pat wrote:
> Hi folks,
> I am trying to use a mysql database as the data source for
> Staroffice 7 & Openoffice. I downloaded mysql-connector-java-3.1.7 &
> installed it & set up Staroffice & openoffice to use it to connect to the
> mysql database. This allowes Staroffice & OPenoffice to connect to the
> database & see the tables but wont allow me to write to or modify the
> database in any way. Whether i connect as the mysql admin. or an ordinary
> user makes no difference even though i can work at the command line when
> logged in to the mysql database as admin. or an ordinary user. Using the
> mysql GRANT command i have granted all privileges to an ordinary user
> followed by FLUSH PRIVILEGES. any help would be appreciated.
Have a look at the FAQs on http://dba.openoffice.org as I thinkthat this is
usually something to do with no primary key being defined.
CPH
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
