Microsoft Access table

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
4 posts Page 1 of 1

progers

Posts: 5
Joined: Mon Feb 10, 2014 10:33 am

Post by progers » Tue Apr 08, 2014 1:56 pm
I’m trying to find out if there’s any way to read in a table from a Microsoft Access database. Using GoAnywhwere.

I chatted online with Duane and found out there's no Access JDBC driver available but was wondering if I could somehow use an ODBC connection set up with an Access driver?

Just don’t want to spin my wheels if it truly cannot be done.

Thanks
Paul

Support_Jon

Support Specialist
Posts: 62
Joined: Thu Jul 19, 2012 9:15 am
Location: Ashland, NE

Post by Support_Jon » Tue Apr 08, 2014 3:08 pm
Hey Paul,

You are in luck as you can connect to a Microsoft Access Database using GoAnywhere Director. GoAnywhere uses the very popular JDBC standard for connecting to databases. A JDBC bridge (or access gateway) is available to bridge the gap to your OBDC connection, you just need to track down the one specific to your version of Microsoft Access. Although Director doesn't include the needed driver by default, it is possible to download the driver and use it with our application.

Simply download the driver from the online source of your choosing and install it into our application and follow that with a restart. Then you will be able to easily retrieve the data you need from your Microsoft Access Database.

Please follow the instructions found in this forum post to aid you in placing the downloaded.jar file into the appropriate folder within GoAnywhere. http://www.goanywhere.com/forum/post163.html#p163

LeSteph

Posts: 1
Joined: Mon Jul 06, 2015 3:43 am

Post by LeSteph » Thu Jul 09, 2015 9:41 am
Hi,

I try to find a JDBC driver could be implemented inside Go Anywhere Director to link some MS Access 2013 DB.

I found some of them for MS Access 2013, but currently no in JAR file extension and not really usefull to configure with GAD

Any help or link is appreciate

Thanks in advance

Steph

Support_Rick

Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Thu Jul 09, 2015 10:20 am
LeSteph,

As Jon pointed out in an earlier post, you can download the JDBC (Gateway) of your choosing. The link he posted How to add JDBC driver to GADirector will explain how to add the driver to GADirector and allow you to utilize it.

This is totally an end-user option to add the driver. We just make it accessible to GADirector.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
4 posts Page 1 of 1