Hello Alan,
Thank you for that link. It gives me hope that it can be done. I forgot to mention we don't have any Java knowledgeable programmers here, hence the reason we're using Scott's JDBC stuff. I'm doubtful that my boss will allow me the time to learn enough Java to figure out how to do this.
I'm hoping someone has already "invented this wheel" so I don't have to.
Thanks again,
Jay
-----Original Message-----
From: JAVA400-L [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of java400-l-request@xxxxxxxxxxxx
Sent: Monday, January 29, 2018 10:00 AM
To: java400-l@xxxxxxxxxxxx
Subject: JAVA400-L Digest, Vol 16, Issue 1
Send JAVA400-L mailing list submissions to
java400-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.midrange.com/mailman/listinfo/java400-l
or, via email, send a message with subject or body 'help' to
java400-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
java400-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific than "Re: Contents of JAVA400-L digest..."
Today's Topics:
1. Has anyone connected to an MS Access database (Jay Triche)
2. Re: Has anyone connected to an MS Access database (Alan Campin)
----------------------------------------------------------------------
message: 1
date: Mon, 29 Jan 2018 17:31:03 +0000
from: Jay Triche <JTriche@xxxxxxxxxxxxx>
subject: Has anyone connected to an MS Access database
Hello all,
I'm posting to the Java group since I suspect JDBC or a combination of JDBC & ODBC would be the preferred method for connecting to a MS Access database from RPG.
We are currently using Scott Klement's JDBCR4 routines to access MS SQL and Oracle databases.
I've scan the Java list for the past 4 years and 'Haven't seen any mention of MS Access.
Does anyone know how to access a Microsoft Access database from the IBM i?
We're on 7.1 and actively planning our move to 7.3. We're in the process of updating to Java 8. I think our production system is still Java 6.
Thanks,
Jay Triche
Senior Programmer/Analyst
Lamps Plus
------------------------------
message: 2
date: Mon, 29 Jan 2018 09:38:03 -0800
from: Alan Campin <alan0307d@xxxxxxxxx>
subject: Re: Has anyone connected to an MS Access database
You need a Type 4 JDBC driver. You need to know if you can access Access with a JDBC type 4 driver.
Found this.
http://ucanaccess.sourceforge.net/site.html
On Mon, Jan 29, 2018 at 9:31 AM, Jay Triche <JTriche@xxxxxxxxxxxxx> wrote:
Hello all,
I'm posting to the Java group since I suspect JDBC or a combination of
JDBC & ODBC would be the preferred method for connecting to a MS
Access database from RPG.
We are currently using Scott Klement's JDBCR4 routines to access MS
SQL and Oracle databases.
I've scan the Java list for the past 4 years and 'Haven't seen any
mention of MS Access.
Does anyone know how to access a Microsoft Access database from the IBM i?
We're on 7.1 and actively planning our move to 7.3. We're in the
process of updating to Java 8. I think our production system is still Java 6.
Thanks,
Jay Triche
Senior Programmer/Analyst
Lamps Plus
--
This is the Java Programming on and around the IBM i (JAVA400-L)
mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
https://archive.midrange.com/java400-l.
------------------------------
Subject: Digest Footer
--
This is the Java Programming on and around the IBM i (JAVA400-L) digest list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/java400-l.
------------------------------
End of JAVA400-L Digest, Vol 16, Issue 1
****************************************
midrange.com
