Error in Connection

[Rakesh Keerthi]

Hi i'm using an excel sheet as back end and making a jdbc connection. and it is throwing some error.

The code is as below

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package javaapplication1;

import java.sql.*;

/**
 *
 * @author U0138039
 */
public class JavaApplication1 {

    static 
    {
        try  { 
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } 
        catch (Exception e) {
            System.err.println(e);
        }
    }

    public static void main(String args[]) {
        Connection conn=null;
        Statement stmt=null;
        String sql="";
        ResultSet rs=null;
 
        try {
            conn=DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Excel Driver(*.xls)};DBQ=D:/Book2.xls","","");
            stmt=conn.createStatement();
            sql="select * from [Sheet1$]";
            rs=stmt.executeQuery(sql);
 rs=stmt.executeQuery(sql);
       
ResultSetMetaData rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();
       int count = rsmd.getColumnCount();
       System.out.print(count);
        } 
        catch (Exception e){
            System.err.println(e);
        } 
        finally {
            try{
                rs.close();
                stmt.close();
                conn.close();
                rs=null;
                stmt=null;
                conn=null; 
            }
            catch(Exception e){}
        }
    }
}

and the error i'm getting is

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

my file is placed in D drive with name as Book2.xls and my configurations are 32bit java, 32 bit netbeans. but my os is Win7 64bit.

but when i do the same with a dsn created, it is working fine. but when i run with no dsn created(created at runtime), it is giving me that error.

Thanks