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).
Essentially, PocketQuery loads the JDBC driver like this:
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:
I am trying to connect PocketQuery to a local MS-Access DB but I have no idea what to enter as URL and driver...i tried the above http://ucanaccess.sourceforge.net/site.html but somehow didn't succeed. Taking a CSV may be a last resort but also here I am lacking knowledge what to enter into PocketQuery's "Add DataSource"-dialogue...
thx and br
hello @Christian Koch
thank you for the response. No I had the file local on C and tried to point to it. But taking your words, if I succeeded to put the file in confluence page and would get the link to it and enter it in PocketQuery's "add database" this would work? (Sorry I am really newbie and I have no clue -except for some general understading- what I have to enter in that mask...:-/) thx and br Björn
Hi @bjoern.florack ,
No this is not possible. The way Confluence stores the attachments in a page and the file system restrictions on the server system will not allow to do so. Ask you server administrators whether it is possible to sync the tables you need into a database server in your company like PostgreSQL, MySQL, or any other database. Or the colleagues will allow you to store the MDB file directly on the file system. But that is normally not allowed.
Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events