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

--
[ 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 mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.