problem with JDBC for talking to Microsoft Access database using a Java Applet
 

Hi all,

For my undergraduate dissertation I am programming in Java and using JDBC to talk to a MS Access database. I have managed to talk to the database and extract the data without any problems using a normal Java application. But as soon as I then convert this exact code to become an Applet then it errors out and complains about the JDBC driver.

The error I get when I run the Applet is:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at SelectApp3.start(SelectApp3.java:31)
at sun.applet.AppletPanel.run(AppletPanel.java:377)
at java.lang.Thread.run(Thread.java:534)


My code is in the attachment to this thread.
Thanks,
Phil.

I think the machine running the applet would need to have an ODBC connection setup. I'm not even sure if an applet could use the machine's ODBC connection because of security restrictions.

Yeah, have set up the ODBC connection and everything like that as i had it working for the Java App - and nothings changed since then as far as i know so it cant be that.

problem with JDBC for talking to Microsoft Access database using a Java Applet

Thank you for proving you can copy and paste.