How do i connect my java program to ms sql server

I am beginner and I would like to create a connection to ms sql server and I have an Error Message: java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://192.168.1.251:1433/adsEngine


Here is my code:
 
import java.sql.Connection;
import java.sql.DriverManager;
 
public class DBMS {
	
	public DBMS(){
		
	}
    public static String strErrorDtls = "";
    
    /** Get database connection */
    public  Connection getConnection() {
        Connection conn = null;
        try {
 
            String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
 
            String uri = "jdbc:microsoft:sqlserver://192.168.1.251:1433/adsEngine";
           
            Class.forName(driver);
 
            conn = DriverManager.getConnection(uri, "", "");
            System.out.println("connection is up");
        } catch (Exception ex) {
            ex.printStackTrace();
            strErrorDtls += ex.getMessage() + " ";
        }
        return conn;
    }    
    
    public static void main(String args[]){
    	DBMS dbms = new DBMS();
    	dbms.getConnection();
 
 
    }
}

Open in new window

dharween0629Asked:
Who is Participating?
 
gnoonCommented:
You need to have database driver (typicaly a .jar file) from database vender (maybe d/l from website), and place it in java classpath (or run setup.exe to automatic set for you) on your matchine before run program.

D/L Microsoft SQL Server 2005 JDBC Driver 1.2 from here http://www.microsoft.com/downloads/details.aspx?familyid=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.