Ask Your Question
0

Base connecting to SQLite db on a Macbook

asked 2018-05-29 21:27:06 +0100

Kopfschlaeger gravatar image

I want to bring an sqlite database into Base. Java development kit is downloaded. I downloaded mysql-connector-java-5.1.23-bin.jar.zip, but cannot open it. (1) where do I get the right version for Mac and (2) what do I do with the file once I have it (e.g. where does it go)?

edit retag flag offensive close merge delete

Comments

2

Hello,

Know very little about Mac but here is a bit of info. On Linux have never gotten connection to SQLite using JDBC (Java connector). Only way was to use ODBC. Not sure where to get this for Mac as all I can find (without cost) is for Linux & Windows. Also, here is my post on setting up -> Base: how to connect to an SQLite database?

Ratslinger gravatar imageRatslinger ( 2018-05-29 23:28:16 +0100 )edit

1 Answer

Sort by » oldest newest most voted
2

answered 2018-05-29 23:58:45 +0100

Ratslinger gravatar image

updated 2018-05-30 01:03:36 +0100

Hello,

Did a little more searching. First make sure you install Oracle JDK (Java) first. Base will not work at all without this.

Here is a post which describes how to use SQLite in OS X -> Use LibreOffice Base as a GUI for an SQLite database in OS X. Link for driver is there also.

Edit:

It may not be necessary to install JDK when using ODBC connector. However some functionality is lost (Report Builder, Wizards and possibly a bit more).

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

edit flag offensive delete link more

Comments

1

It might be worse than it appears. See this bug report (mine!) and the comment trail under it. At the moment would-be Base users might be scuppered on OSX, but I might be missing something.

David gravatar imageDavid ( 2018-05-30 00:53:26 +0100 )edit

@David Please see edit in answer.

Ratslinger gravatar imageRatslinger ( 2018-05-30 01:04:04 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-05-29 21:27:06 +0100

Seen: 261 times

Last updated: May 30 '18