Thread: Problems in connecting to a SQL Server 2008 database "Student"

//STEP 1. Import required packages

import java.sql.*;


public class JDBCCreateTable {

// JDBC driver name and database URL

static final String JDBC_DRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver" ;
static final String DB_URL = "jdbc:microsoft:SQLSERVER://SQLEXPRESS:Student";


// Database credentials

static final String USER = "sa";
static final String PASS = "sasa";

public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;

try{

//STEP 2: Register JDBC driver

Class.forName("com.microsoft.sqlserver.jdbc.SQLSer verDriver");

//STEP 3: Open a connection

System.out.println("Connecting to database...");
conn = DriverManager.getConnection(DB_URL,USER,PASS);


//STEP 4: Execute a query

System.out.println("Creating statement...");
stmt = conn.createStatement();
String sql;
sql = "SELECT StudentID, StudentName, StudentAddress, PhoneNumber FROM StudentName";
ResultSet rs = stmt.executeQuery(sql);

//STEP 5: Extract data from result set

while(rs.next()){

//Retrieve by column name

int id = rs.getInt("StudentID");
int age = rs.getInt("StudentName");
String first = rs.getString("StudentAddress");
String last = rs.getString("PhoneNumber");

//Display values

System.out.print("StudentID: " + id);
System.out.print("StudentName: " + age);
System.out.print("StudentAddress: " + first);
System.out.println("PhoneNumber: " + last);
}


//STEP 6: Clean-up environment

rs.close();
stmt.close();
conn.close();
}catch(SQLException se){

//Handle errors for JDBC

se.printStackTrace();
}catch(Exception e){

//Handle errors for Class.forName

e.printStackTrace();
}finally{

//finally block used to close resources

try{
if(stmt!=null)
stmt.close();

}catch(SQLException se2){
}

// nothing we can do

try{
if(conn!=null)
conn.close();
}catch(SQLException se){
se.printStackTrace();
}
//end finally try
}

//end try

System.out.println("Goodbye!");
}
//end main

}


I get the following exception though I have downloaded the jar file from the microsoft site and saved it in the build path for eclipse.

java.sql.SQLException: No suitable driver found for jdbc:microsoft:SQLSERVER://SQLEXPRESS:Student
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at JDBCCreateTable.main(JDBCCreateTable.java:32)