Hi Sorry if this is a duplicate post I am having machine problems I have written an app in win2000 pro it reads an excel spreadsheet and updates the data to an AS400 file. Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ); connectionstr = "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=" + path + file + ";DriverID=22;READONLY=true"; It all works fine and dandy on the pc side. I move the class to the AS400 and when I try running it under qshell I get. 'java.sql.SQLException: No suitable driver' I think the problem is that we are on os400 v5.1 and there is only jdk1.3 on the as400. We are not going to upgrade to os40
More>>

Hi

Sorry if this is a duplicate post I am having machine problems

I have written an app in win2000 pro it reads an excel spreadsheet and updates the data to an AS400 file.

It all works fine and dandy on the pc side. I move the class to the AS400 and when I try running it under qshell I get.
'java.sql.SQLException: No suitable driver'

I think the problem is that we are on os400 v5.1 and there is only jdk1.3 on the as400. We are not going to upgrade to os400 v5.2 yet (and I can't wait), so no JDK1.4. If there is a away around i.e. copying jar's to the as400 class path etc could someone tell me which files need to be copied.

The problem is that you have no sun.jdbc.odbc.JdbcOdbcDriver on the AS400.

Where is the java class executing? Is it executing on the AS400 or on the client side. If it is an applet running on the client side. Then you might need to jar the applet up, together with the JDBC-ODBC driver, so when the applet jar file is loaded to the client side, it is available there.

The JDBC-ODBC driver won't execute on the AS/400 server side, cause it's written for the intel processor not the AS/400 ML.