Linux/Java - Connection to MS Access database

Java, C++, C#, Delphi, ??? - Using the UNO bridges

Linux/Java - Connection to MS Access database

Postby mr_welby » Wed Jan 23, 2008 3:42 pm

Hi,

On my Linux machine, I need to connect to a MS Access database. I noticed that OpenOffice 2 is able to connect to it by using the Database wizard.

- How the connection is done?
- Which driver is used to connect to it?
- Is there a way to run the wizard in background?
- Where can I find the part of code which is used to connect to a MS Access Db?

Kind regards,

Welby
mr_welby
 
Posts: 2
Joined: Wed Jan 23, 2008 3:29 pm

Re: Linux/Java - Connection to MS Access database

Postby DrewJensen » Thu Jan 24, 2008 2:49 am

The Linux distributions have for the most part dropped MS Access as a supported connection type. The feature was relying on MDBTools and this was seen as not stable enough for production use.

Some have tried using ODBC under linux with the same driver to connect but it appears they are having very little luck - I beleive that bottom line is that if you really want to use Base with MS Access you need to be on Windows.

If all you want to do is migrate the data to a Base file, then you can export the data from MS Access into csv files and import it under Linux.
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
User avatar
DrewJensen
Volunteer
 
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA

Re: Linux/Java - Connection to MS Access database

Postby mr_welby » Thu Jan 24, 2008 12:11 pm

Thanks for you reply.

It seems that the migration is inevitable. :-(

I will export the data from MS Access into csv files and import it under Linux.

Thanks,

Welby
mr_welby
 
Posts: 2
Joined: Wed Jan 23, 2008 3:29 pm


Return to External Programs

Who is online

Users browsing this forum: No registered users and 2 guests