Joined: 05 Oct 2011
|Posted: Wed Nov 02, 2011 1:35 am Post subject: The connection to the data source could not be established.
After digging around on the web for quite some time, and in spite of many threads speaking of the matter, none seems to have been properly answered (or is just me).
So, this is what I’m trying to do:
Simple connect to a Microsoft Access database
And I get the following error
The connection to the data source "Dados" could not be established.
SQL Status: HY000
The connection to the external data source could not be established. No SDBC driver was found for the given URL.
A connection for the following URL was requested "sdbc:ado:access:PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=\\gvsrv05\Valco\Producao\Gestao_Pinhal\db\Dados.mdb".
The funny of this is, it works in OpenOffice 3.3.0 but does not in LibreOffice 3.4.3…
I like LibreOffice :’( and I’m using windows.
My first guess was: we are missing a library (a jar maybe)
Although mentioned in other posts the reinstallation/rebooting does no solve the problem
Thanks in advance