• 0

[Java] MS access driver for mac/linux?


Question

Hi guys just a quick question, I've recently purchased a MacBook and installed the netbeans and opened a existing project that had developed using MS Access database(this can't be changed due to coursework).

No matter what i've tried I am unable to connect to the .mdb , I was wondering if it is possible at all to connect to the the database on a mac or linux?

Thanks

Matt

Link to comment
https://www.neowin.net/forum/topic/887410-java-ms-access-driver-for-maclinux/
Share on other sites

7 answers to this question

Recommended Posts

  • 0

You should be able to use ODBC using the JDBC bridge driver:

static {
	try {
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	} catch (ClassNotFoundException ex) {
		System.err.println("JDBC Bridget Driver not found.");
	}
}

public static Connection getConnection(string fileName) {
	string connection = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + fileName + ";DriverID=22;ReadOnly=false;";
	return DriverManager.getConnection(connection, "", "");
}

  • 0

I've tried this and a I get the following error

java.sql.SQLException: No suitable driver found for jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=/Users/Matt/Documents/CSSD/Application/database.mdb;DriverID=22;READONLY = FALSE}

  • 0
  On 30/03/2010 at 11:09, dontocsata said:

Do you have the jar with that Driver on the Classpath? It looks like you forgot to copy to jar over perhaps? Java is platform independent, so nothing (in general) special needs to be done when you switch to Linux or Mac.

Sorry how do I get the jar? I'm pretty new to java development, so simple lumens terms would be brilliant :D

  • 0

Alright, in Java to access a Database you need a 'Driver.' Drivers are specific to the type of database you're connecting to (mysql, postgresql, ms access). They are usually in a jar file and you put them in your lib folder. The original project probably had the driver you needed. Also make sure you're using the same SDK version.

Then you do what Antaris said:

static {
        try {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Class forName("driver.class.name"); //this is the class of the Driver, the Driver maker will have information for which class to use
        } catch (ClassNotFoundException ex) {
                System.err.println("JDBC Bridget Driver not found.");
        }
}

public static Connection getConnection(string fileName) {
        string connection = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + fileName + ";DriverID=22;ReadOnly=false;";
        return DriverManager.getConnection(connection, "", "");
}

Here is a list of Drivers for MS Access: http://developers.sun.com/product/jdbc/drivers/search_results.jsp?jdbc_version=0&vendor_name=&cert_mode=and&jdbc_driver_type_mode=and&dbms=6&dbms_mode=and&features_mode=and&results_per_page=50&submit=Search

Here is instructions about these Drivers: http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html

It would also be useful if you posted some code you're using. The code to connect to the database would be helpful.

  • 0

Ok this is the code

 public ResultSet insertDataConnection(String sql) throws Exception, SQLException{
        //String fileName = "C:\\Database\\database.mdb";
        String fileName = "/Users/Matt/Documents/CSSD/Application/database.mdb";
        String dbString = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + fileName + ";DriverID=22;READONLY = FALSE}";
        ResultSet results = null;
        System.out.println(DriverManager.getConnection(dbString,"",""));

        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            connection = DriverManager.getConnection(dbString);
            statement = connection.createStatement();
            results = statement.executeQuery(sql);
            return results;
        }
        catch(Exception e){
            //System.out.println(e);
        }
        return null;
    }

    private static Connection getConnection() throws Exception {
        String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
        String url = "jdbc:odbc:database.mdb";
        String username = "";
        String password = "";
        Class.forName(driver);
        return DriverManager.getConnection(url, username, password);
    }

if it is any help also I'm using netbeans!

And for the MS access driver is there any that are free all the ones i can see are paid/trails.

  • 0

I looked around a bit and found this: http://forums.sun.com/thread.jspa?threadID=5380580

You'll need to find a OBJC Driver for Mac/Linux. But it seems that its hard to come by/figure out. I'm sorry I can't help much beyond that. Might just need to Boot Camp or virtualize Windows for your course.

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Black Myth: Wukong hits Xbox this August, exactly a year after PlayStation launch by Pulasthi Ariyasinghe Developer Game Science delivered one of the biggest action games of all time last year, with Black Myth: Wukong going on to sell tens of millions in its launch month and winning a multitude of awards. However, the title skipped out on a platform it was originally announced to launch in: Xbox. Following a long string of reasons and delays, it seems the port is finally coming to the platform. Today, Game Science announced that the Xbox Series X|S version of Black Myth: Wukong now has a release date, with it landing on August 20, 2025. Pre-orders for the title will become available starting June 18. Interestingly, this Xbox release date is set exactly one year after the original release on PlayStation 5 and PC. Game Science originally stated that the delay was due to technical issues with Xbox consoles. However, Microsoft refuted that claim quickly and alluded that the delay was due to some sort of console exclusivity deal between Game Science and Sony. In today's announcement, Game Science once again says that the delay was due to its work on porting the game to Xbox and meeting its quality standards. "Bringing Black Myth: Wukong to Xbox Series X|S—and ensuring the experience met our internal quality standards—was no easy feat," said the studio today regarding the long delay on Xbox platforms. "Fortunately, we were able to complete this challenging task smoothly within the first year of the game's official release." "If you're an Xbox player who hasn't yet experienced the game on another platform, we're confident it will stand among the finest ARPGs available on Xbox," added Game Science. For those looking to jump into the game a little cheaper than usual, Game Science will be hosting Black Myth: Wukong's first-ever sale on June 18. The 20% off discount will be available across PC, PlayStation, and even the Microsoft Store for the Xbox Series X|S pre-order.
    • And where is "don't be evil"? Oh, yeah, they removed it, too.
    • YouTube isn't a monopoly, it's just the most popular video platform, but other options and competitors do exist. And I'm not defending YouTube here, I'm a subscriber to Geerling's channel and I like his content and YouTube clearly went too far with this, but they can't be considered a monopoly, IMO. https://www.captions.ai/blog-post/youtube-alternatives
    • Harmful to them because it affects their business. *Sigh*
  • Recent Achievements

    • Week One Done
      theevergreentree earned a badge
      Week One Done
    • Dedicated
      Fryer Tuck earned a badge
      Dedicated
    • Week One Done
      luxoxfurniture earned a badge
      Week One Done
    • First Post
      Uranus_enjoyer earned a badge
      First Post
    • Week One Done
      Uranus_enjoyer earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      439
    2. 2
      +FloatingFatMan
      247
    3. 3
      snowy owl
      226
    4. 4
      ATLien_0
      212
    5. 5
      Xenon
      152
  • Tell a friend

    Love Neowin? Tell a friend!