Connecting a Microsoft Access Database to Java using JDBC and compiling -

for school database project making database program (user gui , database). using microsoft access 2010 created database , populated sample data, , saved in .mdb format , placed in project folder.

when running in eclipse following code works fine, connects , retrieves query. find unable export code jar , run (which required project, give them working copy of program on cd or flash drive), , i'm unable port code on netbeans have work, trying compile on linux machine.

i assume problem including drivers or trying use microsoft access. error when running jar or running on netbeans given below code. ask either how include drivers make program portable, or how else can approach problem?

thanks in advance

import java.sql.*;  public class jdbctest {     static connection connection;     static statement statement;      public static void main(string args[]){          try {             class.forname("sun.jdbc.odbc.jdbcodbcdriver").newinstance();             string database = "jdbc:odbc:driver={microsoft access driver (*.mdb)};dbq=tldatabasedbm.mdb";             connection = drivermanager.getconnection( database ,"","");               buildstatement();             executequery();          }catch(exception e){             e.printstacktrace();             system.out.println("error!");         }     }      public static void buildstatement() throws sqlexception {         statement = connection.createstatement();     }      public static void executequery() throws sqlexception {          boolean foundresults = statement.execute("select * tblstaff  x city='calgary'");         if(foundresults){             resultset set = statement.getresultset();             if(set!=null) displayresults(set);         }else {             connection.close();         }     }      public static void displayresults(resultset rs) throws sqlexception {         resultsetmetadata metadata = rs.getmetadata();         int columns=metadata.getcolumncount();         string text="";          while(rs.next()){             for(int i=1;i<=columns;++i) {                 text+=""+metadata.getcolumnname(i)+":\t";                 text+=rs.getstring(i);                 //text+="</"+metadata.getcolumnname(i)+">";                 text+="\n";             }             text+="\n";         }          system.out.println(text);      } } 

the error mentioned above:

 java.sql.sqlexception: [microsoft][odbc driver manager] data source name not found , no default driver specified         @ sun.jdbc.odbc.jdbcodbc.createsqlexception(jdbcodbc.java:6957)         @ sun.jdbc.odbc.jdbcodbc.standarderror(jdbcodbc.java:7114)         @ sun.jdbc.odbc.jdbcodbc.sqldriverconnect(jdbcodbc.java:3073)         @ sun.jdbc.odbc.jdbcodbcconnection.initialize(jdbcodbcconnection.java:323)         @ sun.jdbc.odbc.jdbcodbcdriver.connect(jdbcodbcdriver.java:174)         @ java.sql.drivermanager.getconnection(drivermanager.java:582)         @ java.sql.drivermanager.getconnection(drivermanager.java:207)         @ tldatabase.dataconnect.makeconnection(dataconnect.java:35)         @ tldatabase.main.main(main.java:24) 

i know post years ago felt answering question experiencing right now. took me while know answer question here's solution:

http://wiki.netbeans.org/faqsettingheapsize

follow "running 32-bit jvm".

all have find netbeans.conf in installation folder of netbeans , change directory this:

netbeans_jdkhome="c:\program files\java\jdk1.6.0_24"

to this:

netbeans_jdkhome="c:\program files (x86)\java\jdk1.6.0_21"

the problem netbeans might running in 64 bit ms access support 32-bit. doing solve problem. make sure install this:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734