[libreoffice-users] Re: Base / Postgresql support

2011-08-07 Thread Walt
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

2011-08-06 Thread ponsiarceds
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

2011-08-05 Thread ponsiarceds

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