1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Unable To Connect To Access File Using Eclipse

Discussion in 'MS Access' started by girish979, Jan 13, 2010.

  1. girish979

    girish979 New Member

    Joined:
    Nov 18, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Hi,
    Im trying to connect to MsAccess file using Eclipse, but im getting the error

    Code:
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.
    I have added the ojdbc14.jar to Bulid Path for the project & the access file is in the Bin Folder.

    & this is the code
    Code:
    try
            {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    
                           Connection con = DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=testdb2.mdb","","");
                
                      
                Statement stmt = con.createStatement();
                String s = "insert into student values(521,'test1');";
                stmt.executeUpdate(s);
                con.commit();
                stmt.close();
                con.close();
                
                
            }
            catch(Exception e)
            {
    
                System.out.println(e);
                
            }
    any idea??
     
  2. girish979

    girish979 New Member

    Joined:
    Nov 18, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    And when i used the CMD to compile i didnt get any errors & im able to execute.
    & i can retrieve the data, but when i insert something it is not being updated in access file.
     

Share This Page