title: Java program to connect to Sql Server and running the sample query From Eclipse
body: <pre><code>package sqlselection;
  import java.sql.Connection;
  import java.sql.DriverManager;
  import java.sql.ResultSet;
  import java.sql.Statement;
  
  public class Sqlselection 
      {
          public static void main(String[] args)
          {
              try
              {
                  Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
  
                  String userName = "sa";
                  String password = "password";
                  String url = "jdbc:microsoft:sqlserver://localhost:1433"+";databaseName=AdventureWorks2008R2";
                  Connection con = DriverManager.getConnection(url, userName, password);
                  Statement s1 = con.createStatement();
                  ResultSet rs = s1.executeQuery("SELECT TOP 1 * FROM HumanResources.Employee");
                  String[] result = new String[20];
                  if(rs!=null){
                      while (rs.next()){
                          for(int i = 0; i &lt;result.length ;i++)
                          {
                              for(int j = 0; j &lt;result.length;j++)
                              {
                                  result[j]=rs.getString(i);
                              System.out.println(result[j]);
                          }
                          }
                      }
                  }
  
                  //String result = new result[20];
  
              } catch (Exception e)
              {
                  e.printStackTrace();
              }
      }
  
  
  }
  
      enter code here
  </code></pre>
  
  <p>The Above is my sample program to connect to the Sql server to run the sample select query from eclipse.</p>
  
  <p>I am getting the below error.</p>
  
  <pre><code>java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
      at java.net.URLClassLoader$1.run(Unknown Source)
      at java.net.URLClassLoader$1.run(Unknown Source)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.net.URLClassLoader.findClass(Unknown Source)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.Class.forName0(Native Method)
      at java.lang.Class.forName(Unknown Source)
      at sqlselection.Sqlselection.main(Sqlselection.java:13)
  </code></pre>
  
  <p>i have added the sqljdbc.jar,sqljdbc4.jar to the library.
  Help to fix this</p>