RE: Connect to Microsoft Access Database from AS400 using java

[David <dmjae2004@xxxxxxxxx>]

Aaron,
 
I though that SQL Server could only be an Application Requester.  Is there a 
vesion where Application Server support was introduced ?  
 
Can you provide a link so I can do some reading to update myself ?
 
Thanks
 
Dave

"Bartell, Aaron L. (TC)" <ALBartell@xxxxxxxxxxxxxx> wrote:
Check out DRDA. An article about it can be found here:
http://www.dbazine.com/mullins_drda.html 

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] 
Sent: Tuesday, November 16, 2004 12:11 PM
To: Java Programming on and around the iSeries /AS400
Subject: RE: Connect to Microsoft Access Database from AS400 using java

Hi Beppe and all,

I am desperately looking for a way to connect to SQL Server database
from As400 using Java.

Any inputs on how it can be accomplished or what jar file I need to use,
will be of great help!

Thanks.

------------------------------------------------------------------------
Ramesh Sethi 


-----Original Message-----
From: java400-l-bounces+ramesh.sethi=poloralphlauren.com@xxxxxxxxxxxx
[mailto:java400-l-bounces+ramesh.sethi=poloralphlauren.com@xxxxxxxxxxxx]
On Behalf Of Beppe Costagliola
Sent: Tuesday, November 16, 2004 4:10 AM
To: Java Programming on and around the iSeries / AS400
Subject: Re: Connect to Microsoft Access Database from AS400 using java

I think there are some FREE drivers for SQLserver but none for Access.
If you know that one exists, can you please tell us ?
Thanks.
Beppe.

----- Original Message -----
From: "Franco Biaggi" 
To: "Java Programming on and around the iSeries / AS400"

Sent: Monday, November 15, 2004 9:11 PM
Subject: Re: Connect to Microsoft Access Database from AS400 using java


> Ashish Kulkarni wrote:
>
> >Hi
> >is it possible to read or update data in Microsoft
> >access database from a java programming running on
> >AS400,
> >If i have to connect to Access database from windows i
> >create a system DSN and then use it, is it possible to
> >do some thing like that from AS400
> >What can i do if i have to read or update data in
> >Microsoft Access database.
> >
> >Ashish
> >
> >__________________________________________________
> >Do You Yahoo!?
> >Tired of spam? Yahoo! Mail has the best spam protection around
> >http://mail.yahoo.com
> >--
> >This is the Java Programming on and around the iSeries / AS400
(JAVA400-L) mailing list
> >To post a message email: JAVA400-L@xxxxxxxxxxxx
> >To subscribe, unsubscribe, or change list options,
> >visit: http://lists.midrange.com/mailman/listinfo/java400-l
> >or email: JAVA400-L-request@xxxxxxxxxxxx
> >Before posting, please take a moment to review the archives
> >at http://archive.midrange.com/java400-l.
> >
> >
> >
> >
> >
> Yes,
> werx simple, usee the JDBC_ODBC driver
>
> -- 
>
------------------------------------------------------------------------
--
---
> *** This messages was scanned for malicious contents ***
>
------------------------------------------------------------------------
--
---
> Franco Biaggi
> CH-6807 Taverne
>
>
> --
> This is the Java Programming on and around the iSeries / AS400
(JAVA400-L)
mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>

--
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L) mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.




--
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L) mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.


--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com