Bug 90976 - Database is not able to link to Access DB on Linux via ODBC
Summary: Database is not able to link to Access DB on Linux via ODBC
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.3.6.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 91079 (view as bug list)
Depends on:
Blocks:
 
Reported: 2015-04-30 17:55 UTC by Lucia Clemens
Modified: 2015-07-21 07:36 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Announcement of error (16.32 KB, image/jpeg)
2015-04-30 17:55 UTC, Lucia Clemens
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Lucia Clemens 2015-04-30 17:55:29 UTC
Created attachment 115225 [details]
Announcement of error

It shows libodbc.so would be missing.
I searched the web for it wondering why no one on LibreOffice added this file.
I only found unixodbc. One seemed to be right and my system told me of an error which tells me that I better change to f**** Windows because Access runs perfectly.
I also tried to copy contents of my Access tables into the new built tables onto a DB under LibreOffice. Not even drag and drop is possible on that poor system.
All I tried upto now ended in queries that didn't accept any change of the data shown.
Is there anything running correctly on LibreOffice-DB (as it also didn't run on OpenOffice-DB)?
Comment 1 MM 2015-05-03 18:00:04 UTC
libodbc.so.1 and libodbc.so.1.0.0 should be in /usr/lib/i386-linux-gnu
If not, maybe you should try to (re-)install it with the packagemanager.
Comment 2 Julien Nabet 2015-05-04 18:44:29 UTC
*** Bug 91079 has been marked as a duplicate of this bug. ***
Comment 3 Robert Großkopf 2015-05-04 19:48:43 UTC
Libodbc.so must be installed by the system, which installs the ODBC-driver. Could be there is a file installed called libodbc.so.2 . Please create a link to this file in the same folder and call this link libodbc.so . It had been worked here with OpenSUSE 12.3 - haven't installed ODBC yet, because I don't need it ...
Comment 4 Alex Thurgood 2015-07-21 07:36:25 UTC
@Lucia: You can not connect to an Access DB on Linux via odbc. This is independent of LibreOffice, so notourbug status.

If you really want to push the boat out, try the UCanAccess JDBC driver instead