[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[Deepak Aravind]

hi this is my code , it is a simple program to print student details using JDBC. But when i run this i got an error in cmd is "C:\Java>javac first.java
C:\Java>java first
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

import java.sql.*;
import java.util.*;

class first{
	static int sno;
	static String sc,sname,rem;
	
	public static void main(String args[]){
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			String url="jdbc:odbc:MyData";
			Connection con=DriverManager.getConnection(url);
			Statement stmt=con.createStatement();
			String sql="select * from stud1";
			ResultSet rs=stmt.executeQuery(sql);
			while(rs.next()){
				sno=Integer.parseInt(rs.getString("RegNo"));
				sname=(rs.getString("Name"));
				sc=(rs.getString("Course"));
				System.out.println(sc);
				
				System.out.println("Course Report");
				System.out.println("======================");
				System.out.println("Student No:"+sno);
				System.out.println("Name:"+sname);
				System.out.println("Course:"+sc);
				
				System.out.println("========================");
			}
		}
		catch(Exception e){
			System.out.println(e);
			System.exit(0);
		}
	}
}

Please assist me .. i am using jdk1.6

[Stefan Evans]

What sort of database are you trying to access?
My first cringe is at using ODBC. Oracle recommends that you use the correct JDBC driver for your database rather than trying to use ODBC.
If you google for that error message, you should find a whole lot of people encountering the same issue.

Have you defined the data source "MyData" in the ODBC configuration?
Is is a system or user DSN? I always had more luck using System DSN.

[Jesper de Jong]

The JDBC-ODBC bridge driver has been removed in Java 8 - it was never meant as something that you should use for real programs.