unable to connect sql server to simple java app through jdbc

[adiotrox]

1.Created this simple program:

import java.sql.*;
public class Au{
public static void main(String args[]){
try{



String str="SELECT * FROM authors";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:MyDataS ource");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(str);
System.out.println("Author ID\tFirst Name");
while(rs.next()){
String id=rs.getString("au_id");
String fname=rs.getString("au_fname");
System.out.println(id+"\t");
System.out.println(fname);

}
con.close();

}
catch(Exception ex){
System.out.println("error occured");
System.out.println("error:"+ex);
}

}

}


*it is getting compiled and when i am running it, an exception message is displayed as "java.sql.sqlexception microsoft odbc driver manager invalid string or buffer length" and i also successfully created the database and table but still this exception.... please help

[Tolls]

Use the proper sql server jdbc driver (you'll have to do a search on Microsofts site to find the one for your version), or jtds possibly.
The JDBC/ODBC bridge is really not a good choice.

[adiotrox]

I am using 64 bit os(windows 7) can you please suggest me or give me the direct link for my version's supportive sql server jdbc driver....please

[Tolls]

Google it from Microsoft.
That's what I'd have to do...

[adiotrox]

i am getting this Microsoft SQL Server JDBC Driver 3.0, a Type 4 JDBC driver... will this also work for type 1 driver???

[Tolls]

Why do you need a Type 1?

[adiotrox]

sql is useless i downloaded that type 4 driver but it's not getting activate.... can you tell me more about java db