DZone ForumsDZone Forums  

Go Back   DZone Forums > Community > Databases & SQL > Microsoft Access
FAQ Members List Calendar Search Today's Posts Mark Forums Read

 
LinkBack Thread Tools Display Modes

Topic: frazzled about connecting to dbase (MS Access)
Old 07-12-2008, 12:16 PM   #1 (permalink)
Member
 
Join Date: Jul 2008
Posts: 1
hi,

am trying to change from WXP to Linux... at the moment am trying to get Eclipse working...

in fact I've got it working very easily... but I'm having less success connecting to an MS Access dbase.
Code:
   // try to set up driver
    try { Class.forName("org.apache.derby.jdbc.EmbeddedDriver");}
    catch (Exception e) {
      e.printStackTrace();
    }

    // try to connect to the dbase
    try { c = DriverManager.getConnection( "jdbc:derby:/media/sda5/TM proj/ragbag.mdb", "", ""); }
    
    catch (Exception e) {
      e.printStackTrace();
    }
I'm getting:
1) java.lang.ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver

2) java.sql.SQLException: No suitable driver found for jdbc:derby:/media/sda5/TM proj/ragbag.mdb

somebody in some forum somewhere said sthg about adding a classpath so the driver would be accessible... but where is it? Someone else said sthg about a plug-in for Eclipse... yet other people have said MS Access is difficult to connect to in Linux (in which case I would have to try to convert it to another format)...

as you can see, I'm floundering and need an ABC about what I do to set up the driver and then connect

all enlightenment gratefully received

Mike
mrodent is offline   Reply /w Quote -


Thread Tools
Display Modes




All times are GMT -5. The time now is 06:03 PM.