Hi all..

I am having a table named "login" in MS access..
I am connecting it to a java application with th help of the following code..

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("Driver loaded");
// Establish a connection
connection = DriverManager.getConnection("jdbc:odbc:ESMDB");
System.out.println ("Database connected");
String result="";
st = connection.createStatement();
rs = st.executeQuery("SELECT * FROM Login");

while(rs.next())
{

String user= rs.getString(1);
String pw=rs.getString(2);
System.out.println(username+password);

I am getting null value when i try to execute "select * from Login"..
what could be the reason..?Someone help in this regard as early as possible.


Regards,
Balagurunathan S