Hi Hinrich, > What's so wrong with using the "Anything more you want to appear here? > Write us!"-button on http://dba.openoffice.org/FAQ/common.html?
It was more intended if you want to contribute an answer to a FAQ, not a question :) >>>With OpenOffice.org 2.0.1 I am using mySQL (version 3.23.55.) as >>>database, the connection driver is JDBC (8.0.0.8971). >>>My problem is I can't make any changes to the database, except creating >>>new colums. >>>When trying to edit a table via "tables > edit" all the fields are >>>greyed out. >>>... >>Are you using MySQL/JDBC or JDBC directly (verify in >>Edit|Database|Connection Type)? > To reply to your question: I am using JDBC directly. That's the problem :). The MySQL/(JDBC|ODBC) bridge exists exactly because the mere native drivers do offer all functionality. In particular, there is no standard for the SQL syntax for editing table columns, so a generic JDBC driver can never provide this functionality. The MySQL/JDBC driver in OOo cares for MySQL's specialities, so you should always use this one. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
