RE: Suck data from MS Access to AS400

There are third party JDBC drivers available. Usually these are JDBC-ODBC Bridge products. I found a nice list here: http://developers.sun.com/product/jdbc/drivers/browse_all.jsp


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Friday, November 21, 2008 9:12 AM
To: Midrange Systems Technical Discussion
Subject: Re: Suck data from MS Access to AS400

Only if MS provides a type 4 JDBC driver for Access, which I don't believe they do since Access is not a true RDBMS.

I supose if you have an SQL server or DB2 server or otherwise, you could use a type 4 JDBC driver to one of those that passed through to the Access DB.

There our some other products, both IBM and third party, that act as a gateway, using ODBC to access the PC based DBs, from the iSeries.

Charles

On Fri, Nov 21, 2008 at 9:19 AM, Tomasz Skorża <t.skorza@xxxxxxxxxxx> wrote:

Hi guys

Dou you know if it is possible to directly sucking data from MS Access
database to AS400 DB2 database (by process/program calling and running
on AS400 - not on Windows station)?

--
Regards

Tomek

---------------------
Please consider the environment before printing this email.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.