sushil parti

Hi
thanks everybody for your help
well somehow my code is running again after i replaced it with following code
but i still can't get how. Does any body know??
if(e.getSource()==b1) { String url,uname,pass,db,query; ResultSet rs; Connection con; Statement stmt; uname = t1.getText(); pass = pw1.getText(); query = "select * from Login where username='"+uname+"'and password='"+pass+"'"; try{ DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver()); db=".//hardware.accdb"; url="jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="+db+";DriverID=22;READONLY=false"; con=DriverManager.getConnection(url); stmt=con.createStatement(); rs=stmt.executeQuery(query); if(rs.next()) { System.out.println("Mission Accomplished"); } else { JOptionPane.showMessageDialog(f, "NO such record found...!!! try again"); t1.setText(""); pw1.setText(""); } } catch(Exception e1) { e1.printStackTrace(); } }

Hi Ireneusz
Thanks for replying....

i changed that relative address to have an absolute one .
But still it is not working properly..

Actually There is no compilation error. But when i click on login button after putting the username and password
the error comes.

any guesses what should i do

Hi,
i am a newbie to java... i have just joined an institute for that and the tutor is teaching java on netbeans
but i liked eclipse more. So i am doing on that.
A few days ago my tutor taught us database connectivity without using DSN so that it could be deployed easily which i have implemented in the code below
But i am getting an error :

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I have checked the code again and again but can't find the error in it. Further my teacher is not able to find the error and is blaming the eclipse for that and is saying it is due to some internal error of laptop. I am not sure what to do ..

please help me a soon as possible..here is the code.. :

package hardwareSales; import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; public class Login implements ActionListener { JFrame f; JPanel p1,p2,p3,p4,p5,p6,p7; JButton b1,b2; JTextField t1; JLabel l1,l2,l3,l4; JPasswordField pw1; Connection con; Statement stmt; ResultSet rs; public void go() { l1=new JLabel("User"); l2=new JLabel("Password"); l3=new JLabel("LOGIN INFO"); l4=new JLabel(" "); f=new JFrame(); p1= new JPanel(); p2= new JPanel(); p3= new JPanel(); p4= new JPanel(); p5= new JPanel(); p6= new JPanel(); p7= new JPanel(); b1= new JButton("Login"); b2=new JButton("Reset"); t1= new JTextField(); pw1= new JPasswordField(); b1.addActionListener(this); b2.addActionListener(this); t1.setMinimumSize(new Dimension(200,20)); t1.setMaximumSize(new Dimension (200,20)); pw1.setMinimumSize(new Dimension(200,20)); pw1.setMaximumSize(new Dimension(200,20)); l1.setMinimumSize(new Dimension (100,20)); l1.setMaximumSize(new Dimension(100,20)); l2.setMinimumSize(new Dimension (100,20)); l2.setMaximumSize(new Dimension(100,20)); p1.setLayout(new BoxLayout(p1,BoxLayout.X_AXIS)); p2.setLayout(new BoxLayout(p2,BoxLayout.X_AXIS)); p3.setLayout(new BoxLayout(p3,BoxLayout.X_AXIS)); p1.add(l1); p1.add(t1); p2.add(l2); p2.add(pw1); p3.add(b1); p3.add(l4); p3.add(b2); p5.add(l3); p4.setLayout(new BoxLayout(p4,BoxLayout.Y_AXIS)); p4.add(p5); p4.add(p1); p4.add(p2); p4.add(p7); p4.add(p3); p4.add(p6); f.add(p4); f.setVisible(true); f.setSize(350,150); f.setLocation(400,280); f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } @SuppressWarnings("deprecation") public void actionPerformed(ActionEvent e ) { if(e.getSource()==b1) { String query,uname,pass,db; uname=t1.getText(); pass=pw1.getText(); query="select * from Login where username='"+uname+"'and password='"+pass+"'"; try { DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver()); db=".//hardware.accdb"; String url = "jdbc:odbc:Driver={ Microsoft Access Driver( *.mdb, *.accdb)};DBQ="+db+";DriverID=22;READONLY=false"; con=DriverManager.getConnection(url); stmt=con.createStatement(); rs=stmt.executeQuery(query); if(rs.next()) { System.out.println("Done!!!!"); } } catch(Exception e1) { System.out.println("I m in catch"); e1.printStackTrace(); } } if(e.getSource()==b2) { t1.setText(""); pw1.setText(""); } } public static void main(String[] args) { Login o1=new Login(); o1.go(); } }

Please reply if any one here knows the solution......
Thank you