can't establish connection to Access db through my java program

[KnightCoder]

i am using windows 98, i have installed jdk1.3.

i have created a simple access database and created a DSN.

i need an example of any java code that establishes connection to an access database using the DNS and executes a simple query with a displayed result.

any help is welcome!

 

[palbano]

Don't know how much help this will be but here it is anyway.

-pete


Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver"
con = DriverManager.getConnection( "jdbcdbc:MYACCS", "", ""
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while( rs.next()){
System.out.println(rs.getString("name&quot + ": " + rs.getString("email&quot );
} // while()

rs.close();
stmt.close();
con.close();

}catch(SQLException sex){
System.out.println("SQLException: " + sex.getMessage());
}catch(Exception ex){
System.out.println( "Exception: " + ex.getMessage());
}