Hi Tom,
Many thanks for ur suggestion. It worked fine in windows machine.
But one thing how can I do that in a Linux machine ?
When I am running the same code that is ...
public class ConnectToMSAccess {
/**
* @param args
*/
public static void main(String[] args) {
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
/*String myDB1 ="jdbc

dbc

river={Microsoft Access Driver (*.mdb)};DBQ=C://data//db1.MDB";*/
String myDB="jdbc

dbc

river={Microsoft Access Driver (*.mdb)};DBQ=//machineName/shared/db2.MDB";
Connection DBConn = DriverManager.getConnection(myDB,"","");
java.sql.DatabaseMetaData dmd = DBConn.getMetaData();
System.out.println("Connected without any DSN !!!");
}
catch(Exception e){
e.printStackTrace();
}
}
}
the follwing exception is coming :
java.sql.SQLException: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3074)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at ConnectToMSAccess.main(ConnectToMSAccess.java:47)
Naturally it is not getting the driver from a Linux machine ,which is there in any windows machine.Any solution ? But thanks again,for ur suggestion.
Regards,
Ayan