Searching for Data Source Provider

asked 2018-01-18 23:22:38 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I'm sure this question has been raised before but I could not find any answer to it

I have downloaded LibreOffice 5.3 running it on Windows 10 64 bit computer with Java 9.

When I try to convert a MS 2007 access file to Base I get a message "The connection to the data source "New Database3" could not be established" and "SQL Status: HY000 The connection could not be created. May be the necessary data provider is not installed."

If I try to open an OpenOffice ODB in LibreOffice I get the same message.

Any information/help that will clarify what I may be doing wrong or need to do will be greatly appreciated.

edit retag flag offensive close merge delete

Comments

LO and Java must both be the same bit size, i.e. both 32 bit or both 64 bit.

peterwt gravatar imagepeterwt ( 2018-01-18 23:34:40 +0200 )edit

@Bill C: Please do not check "community wiki." See guidelines for asking.

Jim K gravatar imageJim K ( 2018-01-19 00:17:12 +0200 )edit

Look at: "How to connect to a Microsoft Access database"

Now, if your proposed conversion of MS Access to Base would be a one shot action where you will be abandoning the MS Access program; you may consider (as one approach) exporting the MS Access database (Assuming it is not too complex) into a text file and then importing it into Base.

Steve R. gravatar imageSteve R. ( 2018-02-19 20:20:25 +0200 )edit