RE: Using ODBC driver from AS/400 -- JAVA400-L

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
I know there are type 4 Java jdcb drivers for sql2000  but not sure, about
access, I remember reading somewhere about the structure of the database not
being conducive... but all it takes is one determined programmer to fix that
problem...  but I don't think you can use the ODBC bridge on the 400...

But you can write a client server module, you could have your as/400 send a
request to your PC, and have your PC, using the ODBC bridge, read the data,
and then pass it back to the as/400...  or you can try this..
http://odbcsock.sourceforge.net/faq.html

just a few random thoughts, that might help...
Tim

> -----Original Message-----
> From: Franco Biaggi [SMTP:fbiaggi@ticino.com]
> Sent: Tuesday, December 24, 2002 9:15 AM
> To:   java400-l@midrange.com
> Subject:      Re: Using ODBC driver from AS/400
>
> --
> [ Picked text/plain from multipart/alternative ]
> Ciao,
> I think that you need and ODBC connection to access it.
> I do not know of any available on AS/400.
>
>
> On Tue, 24 Dec 2002 11:51:01 -0500, Richard Casey wrote:
>
> >Hi!
>
> >I've written a Java program to read information from a Microsoft Access
> >database, "massage" it a bit, and load it into an AS/400 database. I'm
> using
> >the JDBC-ODBC driver to read the Access database along with a tip I
> picked
> >up on how to build the DSN on the fly.
>
> >     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
> >     Connection con = DriverManager.getConnection(
> >                                     "jdbc:odbc:Driver={MicroSoft Access
> Driver (*.mdb)};DBQ="
> >                                             + accessFilename,"","");
>
> >This works fine when I run it from my PC. I would like to be able to run
> it
> >on the AS/400 by putting the Access database file on the IFS and running
> the
> >program in the QSH environment. The program compiles fine, but I get a
> "No
> >suitable driver" SQLException when I try the getConnection against the
> >Access database.
>
> >Am I out of luck or am I just missing something (classpath perhaps)?
>
> >Thanks in advance for any assistance!
>
> >Happy Holidays!
> >Richard Casey
>
>
> >_______________________________________________
> >This is the Java Programming on and around the iSeries / AS400
> (JAVA400-L) mailing list
> >To post a message email: JAVA400-L@midrange.com
> >To subscribe, unsubscribe, or change list options,
> >visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> >or email: JAVA400-L-request@midrange.com
> >Before posting, please take a moment to review the archives
> >at http://archive.midrange.com/java400-l.
>
>
>
> <html>
>
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> <meta name="Author" content="Franco Biaggi">
> <meta name="GENERATOR" content="Franco Biaggi">
> </head>
>
> <body>
>
> <p>&nbsp; </p>
>
> <table BORDER="1" COLS="1" WIDTH="452" BGCOLOR="#FFFF00">
>   <tr>
>     <td width="446"><font face="Comic Sans MS"><small><small><br>
>     <font color="#3333FF"><a
> href="http://www.ticino.com/usr/fbiaggi/";>Franco
> Biaggi</a></font><small><br>
>     <font color="#3333FF"><a href="http://www.sisa.ch";>SISA Studio
> Informatica SA</a></font><small><small><small> <br>
>     </small></small></small><font color="#3333FF">R&amp;D
> Services</font><small><small><small>
>     <br>
>     </small></small></small><font color="#3333FF">Via Carvina
> 1</font><small><small><small> <br>
>     </small></small></small><font color="#3333FF">CH-6807
> Taverne</font><small><small><small> <br>
>     </small></small></small><font color="#3333FF">Efax +1 801 705
> 2839</font></small></small></small><br>
> <br>
> </font></td>
>   </tr>
> </table>
> </body>
> </html>
>
>
> --
>
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review, use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.