https://bugs.freedesktop.org/show_bug.cgi?id=36555
Lionel Elie Mamane <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #28 from Lionel Elie Mamane <[email protected]> 2011-11-20 03:21:22 PST --- There are two layers where this can go wrong: 1) No or non-functional ADO->SDBC driver 2) No Jet->OLE DB provider (driver) ADO is an object wrapper around OLE DB, and Jet is the DB engine behind MS Access mdb files. >From the error message that people get, my guess is that their LibreOffice does not have the ADO->SDBC driver, and this needs to be fixed. In other words, the problem is point 1. Could people having this problem please: 1) check for a file named "*ado*.dll" or something similar in their LibreOffice installation (whether the ADO<->SDBC driver is there). 2) check whether they can access any _other_ database through ADO in LibreOffice. See http://www.carlprothman.net/Default.aspx?tabid=87 for examples. This would establish that LibreOffice <-> ADO works and that the problem is MS Access/mdb-specific. 3) If you have basic Perl scripting skills, see http://www.perlmonks.org/?node_id=117713 for an example script for how to connect to a MS Access mdb file through ADO/OLE DB. Does that work? This would establish that the ADO <-> OLE DB <-> Jet <-> mdb works and that the problem is LibreOffice-specific. Now, about point 2: Note at http://msdn.microsoft.com/en-us/library/ms811968: The Microsoft Jet OLE DB Provider and (...) were removed from MDAC 2.6. http://support.microsoft.com/kb/271908 contains instructions on how to install the Jet OLE DB provider on MS Windows 2003 and earlier. On the other hand, http://support.microsoft.com/kb/239114 suggests that Windows Vista and 2008 already have Jet preinstalled, and presumably the Jet OLE DB provider with it. Don't know about Windows 7. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
