Programming Forums > Application Development > Java

captainK · Feb 14th, 2005, 5:49 PM

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.

Moldz · Feb 14th, 2005, 9:43 PM

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.

captainK · Feb 15th, 2005, 5:22 PM

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.

avianand · Mar 19th, 2005, 9:30 AM

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

Ooble · Mar 20th, 2005, 12:01 PM

Thank you for proving you can copy and paste.

Mar 20th, 2005, 12:01 PM	#5
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	Thank you for proving you can copy and paste. __________________ Me :: You :: Them

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 14th, 2005, 9:43 PM	#2
Moldz Programmer Join Date: Feb 2005 Posts: 54 Rep Power: 4	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.

Feb 15th, 2005, 5:22 PM	#3
captainK Newbie Join Date: Feb 2005 Posts: 5 Rep Power: 0	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.

Mar 19th, 2005, 9:30 AM	#4
avianand Newbie Join Date: Mar 2005 Posts: 1 Rep Power: 0	problem with JDBC for talking to Microsoft Access database using a Java Applet

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)