Hi, first time poster here. I use Netbeans on Ubuntu 10.04.

My project has to do with SQL queries and databases. The main problem I have is that I don't know how to set up the bridge, in Windows I know how but not on my Ubuntu.

Could someone please help? I mainly just need to know how to set up the bridge and if there is a Access type program for Ubuntu. Thanks.

[Sorry for the lack of Detail.]

Here is a post my friends made on the ubuntu forums:

Quote Originally Posted by Frikkie[RSA] View Post
Hi. I would like some help to run sql queries in Ubuntu. For a school IT project, we must write a Java program that runs queries. Seeing that I'm going away on holiday and will be away from my Win7 desktop, I will have to work on my Ubuntu laptop.

When I run my program, I get these two sql exceptions:

sun.jdbc.odbc.JdbcOdbcDriver
No suitable driver found for jdbc:odbc:ITPAT2010
Note: it is not my program that is causing the problem, since it works fine on Win7. But here's my code anyway:

void OpenDB()
   {
        System.out.println("INTO BRIDGE");
        String url = "jdbc:odbc:ITPAT2010";  //JOU BRUG SE NAAM
        try
        {
            Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
        }
        catch (java.lang.ClassNotFoundException e)
        {
            //JOptionPane.showMessageDialog (null,"ClassNotFoundException: "+e.getMessage ());
            System.out.println(e.getMessage ());
        }
        try
        {
            con = DriverManager.getConnection (url, "Admin", "awe");
        }
        catch (SQLException ex)
        {
            //JOptionPane.showMessageDialog (null,"SQLException: " + ex.getMessage ());
            System.out.println(ex.getMessage ());
        }
 
        System.out.println("BRIDGE OPEND");
   }
I believe the drivers that handles the connection to the database aren't installed. The format of my database is: *.accdb (was created on Win7 using Office 2010). I can't open this file, probably because I have no database programs installed?

Anyway, help would really be appreciated, else I will be forced to go back to XP on my laptop in order to get my project done.

Thanks

Oh, I should probably add that I'm using Ubuntu 9.10 - the Karmic Koala.
That pretty much summarizes my problem as well....