Rakesh Khire

Greenhorn
+ Follow
since Oct 17, 2011
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Rakesh Khire

thank you for your welcome Campbell Ritchie, I done as you suggested that i moved my code but still the same problem is there.


F:\Ad_Java\Exp10>javac JDBCDemo.java

F:\Ad_Java\Exp10>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)

F:\Ad_Java\Exp10>





and can you please help me little more and tell me that where can i find .jar??

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