'JDBC SQL Server errors: ClassNotFound & Not Suitable Driver Found

I am very new to Java and am simply trying to connect to my MSSQL database and return a list of customers. When I try the JDBC connection, I get a "no suitable driver found" error. When I add a Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver") statement, I get a ClassNotFound error. This seems like it should be a lot easier than it's turning out to be. Please help me either find a suitable driver or how to get access through the Class.forName usage.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.ResultSet;
import java.sql.Statement;

public class DbConn {

    public static String getConnString(){
        return "jdbc:sqlserver://localhost\\SQLEXPRESS:1433;database=OhHold;";
    }

    public static void getConnection() {
        try
        {
            //Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            String user = "<USER>";
            String pw = "****************";
            Connection connection = DriverManager.getConnection(getConnString(), user, pw);
            Statement statement = connection.createStatement();
            String sql = "select txtCompanyName as company from tblCustomers where intNotActive <> 1";
            ResultSet result = statement.executeQuery(sql);
            while (result.next()) {
                System.out.println(result.getString(1));
            }

        }
        /*
        // Handle any errors that may have occurred.
        catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

         */
        catch (SQLException ex) {
            ex.printStackTrace();
        }
    }

    public static void main(String[] args) {
        getConnection();
    }
}


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source