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!
(In reply to Luigi from comment #1) > Hello! > > using postgresql://localhost:5432/mydb as string connection, the connection > works without problem. > Ratslinger (https://ask.libreoffice.org/en/users/19488/ratslinger/) https://poppyplaytimechapter3.io found > this workaround. Bug related to PostgreSQL SDBC driver not registered in LibreOffice Base on Windows 10 and their workaround to establish connection to PostgreSQL database, note that the issue has been marked as duplicate of another reported bug