Can I get PocketQuery to work with my MS Access DB

Does anyone have experience/success having PocketQuery interface with a MS Access Database?  If so may I have some instructions on what steps were needed to connect?  My Access DB is running on a windows desktop (actually VM).

2 answers

You can access every database with PocketQuery if there is a valid JDBC driver. For MS Access you can try http://ucanaccess.sourceforge.net/site.html but the MDB file must be accessible. Unfortunately we have no experience with that.

Hi @Christian Koch (Scandio) Thanks for your suggestion. I will try it and will provide an update.

Hi Edgar,

Essentially, PocketQuery loads the JDBC driver like this:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")

First, you should make sure you can connect to your database with other Java tools like SquirrelSQL. If this works, it will also work with PocketQuery.

These Stackoverflow threads might be interesting:

Regards, Felix

THanks @Felix Grund (Scandio) I will review the links you suggested and try based on what I learn.

Was this ever resolved? I'm looking at trying the same thing.

@Edgar Green Could you resolve this?

Good morning @Felix Grund (Scandio) We never resolved this. We ended up using a csv file as the source data.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published yesterday in Statuspage

194 years of downtime: looking back on incident data from 2018

Statuspage customers logged more than 194 years of collective incidents in 2018. That’s a whopping 87% increase from the  104 years logged in 2017 , and we aren’t even through December yet....

56 views 1 5
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you