Hi,
I am new to this Java and trying to write following program
import java.sql.*;
public class JDBCDemo
{
public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc: odbc:StudTableDSN");
Statement stmt=conn.createStatement();
String query="select * from StudTable where rollno=2";
ResultSet rs=stmt.executeQuery(query);
rs.next();
System.out.println("Roll No:"+rs.getInt(1));
System.out.println("Name:"+rs.getString(2));
System.out.println("Average:"+rs.getDouble(3));
conn.close();
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException se)
{
se.printStackTrace();
}
}
}
and getting the error
C:\Program Files\Java\jdk1.6.0_23\bin>javac JDBCDemo.java
C:\Program Files\Java\jdk1.6.0_23\bin>java JDBCDemo
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not fou
nd and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3073)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:3
23)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at JDBCDemo.main(JDBCDemo.java:9)
C:\Program Files\Java\jdk1.6.0_23\bin>
friends please help