https://bugs.documentfoundation.org/show_bug.cgi?id=144035
Alex Thurgood <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |RESOLVED Resolution|--- |NOTOURBUG --- Comment #5 from Alex Thurgood <[email protected]> --- @Herman : thanks ! I see various packages for the JDBC driver linked here, depending on the processor architecture you need, e.g. for x86_64 : https://madb.mageia.org/package/show/name/postgresql-jdbc/application/0/arch/x86_64/source/1 After installation of the correct package, you will probably also have to : (1) point LO to the directory in which the postgresql JDBC JARs can be found - this is done via the Advanced menu entry under Tools > Options > Classpath > Add Jar for example, in my setup, I have the following (for an older postgres JDBC connector on macOS) : /Users/alex/JavaDB/postgresql-8.4-702.jdbc3.jar If the connection still won't work with a single jar, then you will have to point LO to the folder containing the various postgresql JARs. (2) fill in the driver name yourself in the connection configuration dialog from within LibreOffice once the ODB file has been loaded. org.postgresql.Driver The connection string is something like : jdbc:postgresql://ipaddressofserver:5432/mydbname or jdbc:postgresql://ipaddressofserver port=5432 dbname=mydbname I seem to recall that the string suggestions in the connection setup dialog provided by LO are incorrect (there is already a bug report for this, but I don't think it has been corrected yet). -- You are receiving this mail because: You are the assignee for the bug.
