Problem description: When opening an MS-Access template, I get the following error : " The connection to the data source "New Database" could not be established. The connection to the external data source could not be established. No SDBC driver was found for the given URL. " I also get the same error after opening, every time I click on the 'Tables' icon/button. Steps to reproduce: 1. Start LibreOffice 2. Click on the 'Database' icon 3. Choose 'connect to an exisiting database' 4. Select 'Microsoft Access' from the drop down list. 5. Click 'next' 6. Click 'Browse', and select the access database template. 7. Click 'Finish' 8. Click 'Save' Current behavior: The message stated above is displayed. Expected behavior: Being able to view/add/edit tables. Platform (if different from the browser): Browser: Mozilla/5.0 (Windows NT 6.0; rv:14.0) Gecko/20100101 Firefox/14.0.1
Created attachment 64817 [details] MS Access Template
Created attachment 64818 [details] MS Access Template
Created attachment 64819 [details] MS Access Template
Sounds like component registration of the driver is screwed again ?? I can't test, since I don't have Access any more, but FWIW, I get the same error with the mysql native connector driver on Mac OSX. Alex
Reproduced with LibreOffice 3.6.0.4 (rc), Windows 7 32 bits. (This bug is Windows-specific, obviously.) Same problem with "any" ADO connection URL. By contrast connecting through ODBC works (including to MS Access .mdb files).
(In reply to comment #4) > I can't test, since I don't have Access any more You don't need Microsoft Access to test, only a .mdb file (attached to this bug) and MDAC (Microsoft Data Access Components) installed. Anyway, this seems indeed to be a registration problem: odbclo.dll is mentioned in none of the .rdb files; it should be mentioned in one of them. @dtardon: I'm "guessing" and blaming this on the gbuildification; could you check this out please? Thanks.
In LibreOffice 3.5 install .msi, unpacked (with 7z under GNU/Linux), I find a libreoffice1.cab. Unpack this file with 7z, it creates a file services1.rdb which contains (among others): <component loader="com.sun.star.loader.SharedLibrary" uri="vnd.sun.star.expand:$LO_LIB_DIR/adolo.dll"> <implementation name="com.sun.star.comp.sdbc.ado.ODriver"> <service name="com.sun.star.sdbc.Driver"/> <service name="com.sun.star.sdbcx.Driver"/> </implementation> </component> OTOH, the same file in LibreOffice 3.6 install .msi does not contain this entry. In contrast, this file in both versions contains: <component loader="com.sun.star.loader.SharedLibrary" uri="vnd.sun.star.expand:$LO_LIB_DIR/odbclo.dll"> <implementation name="com.sun.star.comp.sdbc.ODBCDriver"> <service name="com.sun.star.sdbc.Driver"/> </implementation> </component>
(In reply to comment #6) > (In reply to comment #4) > > I can't test, since I don't have Access any more > > You don't need Microsoft Access to test, only a .mdb file (attached to this > bug) and MDAC (Microsoft Data Access Components) installed. > > > Anyway, this seems indeed to be a registration problem: odbclo.dll is mentioned > in none of the .rdb files; it should be mentioned in one of them. > > @dtardon: I'm "guessing" and blaming this on the gbuildification; could you > check this out please? Thanks. Yes, sure.
Ah, I accidentally removed ado component registration in commit d4efa8b0cf48f092d8984f3f085909cd1a6a39af ...
David Tardon committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7484f81faf2ee4e6bd80b9200ba48ca013434695 fdo#52615 add ADO component to services.rdb again
David Tardon committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d46bd28012890fd0b5ae2dc1f562a9d33eae2639&g=libreoffice-3-6 fdo#52615 add ADO component to services.rdb again It will be available in LibreOffice 3.6.1.
*** Bug 53267 has been marked as a duplicate of this bug. ***