Am Sa, den 12.03.2005 schrieb Lawrence Harriott um 22:33: > Hi Josh, I'm not, but I'll try to help...
> By native I suspect you mean MyODBC. I get the exact same results using > it as using unixODBC. Even the work around seems to work the same for > both. There is a driver for PostgrSQL, look there: http://dba.openoffice.org/drivers/index.html > Additionally, I have used the MySQL downloaded from MySQL and the one > supplied with MDK10.1. Same results. I think at this point it is fair to > say that the problems are not user errors. The ODBC interface between > MySQL / Postgresql and OOo is defective. Not really. ODBC itself is some sort of a wasps nest. You have to: - use version numbers of database and unixODBC/iODBC that "fit together" - watch out for paths, the location of odbc.ini is compiled in, so the best is to compile them yourself (/etc/odbc.ini, /usr/local/etc/odbc.ini, ~/.odbc.ini, ...) - go step by step: test the db for access rights, do that over the local net, test access with isql, then use applications That's the reason why odbc is seen as flaky... > Had this not been the case, I > do not think there would be such a massive effort to develop OOobase, > the XML equivalent to M$ Access, when MySQL and Postgresql are clearly > more mature, powerful and stable DBMS. You are free to choose. HTH, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
