|
midrange.com
--
[ 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> </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&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>
--
As an Amazon Associate we earn from qualifying purchases.
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.
