[libreoffice-users] Re: Base / Postgresql support
Thanks for all the comments. Just thought I'd raise it as is a key feature on http://www.libreoffice.org/features/ Couldn't see a postgresql support via the extension manager and the version on the http://dba.openoffice.org/drivers/postgresql openoffice wiki is about a yr old. I think I will stick to odbc on windows for testing however if I can't get multiple datasources going then unlikely to be useful for me (generally for creating ahoc reports and queries across multiple sources or as a small scale ETL tool) Cheers -- View this message in context: http://nabble.documentfoundation.org/Base-Postgresql-support-tp3226192p3233567.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base / Postgresql support
No luck with the sdbc driver. I disabled the driver then removed it. I even went so far as to rename my /.libreoffice dir, re-install it start afresh. Looking at https://bugs.freedesktop.org/show_bug.cgi?id=35784 the driver is currently broken. JDBC works, but it might be slower. - Ubuntu 10.10 64bit : LibreOffice 3.4.2 OOO340m1 (Build:203) JRE: jre-6u21-linux-x64.bin -- View this message in context: http://nabble.documentfoundation.org/Base-Postgresql-support-tp3226192p3230789.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base / Postgresql support
Walt wrote: Hi Anyone know how to get native pgsql support on base - it seems missing from the connect to an exsitng database options. I've checked under both Linux and Windows. There was a special driver in a zip file available from the old openoffice.org site. It was an extension installed through the (Tools-)Extension Manager I've uploaded it to multiupload here: http://www.multiupload.com/LLL32191L0 (postgresql-sdbc-0.7.6b.zip) I'm afraid I have no idea if it will still work though. Let me check get back to you. Walt wrote: Also is it possble to mix and match datasources on one base database (some local tables + some odbc tables etc) AFAIK there's only one connection string (ODBC, SDBC, JDBC) that can be specified via the (database properties -connection settings:) Datasource URL field. - Ubuntu 10.10 64bit : LibreOffice 3.4.2 OOO340m1 (Build:203) JRE: jre-6u21-linux-x64.bin -- View this message in context: http://nabble.documentfoundation.org/Base-Postgresql-support-tp3226192p3227883.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted