Hello! I first asked this question on ask.libreoffice.org (https://ask.libreoffice.org/en/question/193452/windows-libreoffice-623-postgresql-sdbc-driver-error/) Db installed: PostgreSQL 11.3, compiled by Visual C++ build 1914, 64-bit LibreOffice version: Version: 6.2.3.2 (x64) Build ID: aecc05fe267cc68dde00352a451aa867b3b546ac I can connect to db via psql and pgadmin. The problem occurs when i tried to connect via LibreOffice Base. I downloaded the windows installer and tried to connect to a PostgreSQL db and get this error: "The connection to the external data source could not be established. No SDBC driver was found for the URL". To get this error, i did: (on Windows) 1. Open Libreoffice Base > Database Wizard 2. Select "Connect to a existing database" and select "PostgreSQL". Next 3. Datasource URL. host=localhost:5432 dbname=mydb . Next 4. Username and Test connection at this point i fill the password and get this error: "A driver is not registered for the URL host=localhost:5432 dbname=mydb" I tried without testing the connection and get this error. "SQL Status: HY000 The connection to the external data source could not be established. No SDBC driver was found for the URL host=localhost:5432 dbname=mydb" I didn't find on documentation if the windows binaries came with postgres-sdbc driver.
Hello! using postgresql://localhost:5432/mydb as string connection, the connection works without problem. Ratslinger (https://ask.libreoffice.org/en/users/19488/ratslinger/) found this workaround.
(In reply to Luigi from comment #0) > > The connection to the external data source could not be established. No SDBC > driver was found for the URL host=localhost:5432 dbname=mydb" Did you also try it without adding the port? host=localhost dbname=mydb Have tried it without the port and haven't any problem. If I try to add the port "could not translate hostname localhost:5432" appears. Tested with OpenSUSE 15, LO 6.2.3.2 64bit rpm
Isn't this a duplicate of bug 125168 ?
*** This bug has been marked as a duplicate of bug 125168 ***
(In reply to Robert Großkopf from comment #2) > (In reply to Luigi from comment #0) > > > > The connection to the external data source could not be established. No SDBC > > driver was found for the URL host=localhost:5432 dbname=mydb" > > Did you also try it without adding the port? > host=localhost dbname=mydb > > Have tried it without the port and haven't any problem. If I try to add the > port "could not translate hostname localhost:5432" appears. > > Tested with OpenSUSE 15, LO 6.2.3.2 64bit rpm Hi, Robert! tried this and work fine. Thanks!