Hello Mike, > I'm using com.mysql.jdbc.Driver, version 5.0.5, from the MySQL website, > mysql-connector-java-5.0.5-bin.jar > > I only get back an error message under Tools > Relationships that says: > > "The Database does not support Relationships", > > But MySQL does support relationships, so is this error mal formed? > > Has this been solved and I'm doing something wrong in driver permissions? > Is there a workaround besides hard-coding updates by Macro or other? > Is there a solution planned in the future, if there is no present solution?
For one, there's no possibility (in none of the generic database access APIs such as ODBC, JDBC, ADO) which reliably tells whether a database supports relationships. Thus, if OOo does not know the particular database backend, it applies some magic^Wheuristics to guess whether the backend actually has this support. For MySQL, this heuristic fails (it tells that MySQL doesn't support relationships, while it actually does). Now, if you choose the "MySQL" type in the UI to connect to the MySQL database, then Base *does* know the backend (MySQL, that is), but unfortunately still applies the heuristics (which could be considered a bug). The issue which requests to change this behavior is http://www.openoffice.org/issues/show_bug.cgi?id=68858. I suggest voting for it ... Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
