[DonCash]

What JDK are you using? What editor...?

Use this code. Create a class called connectDS

Code:

import java.sql.*;
import com.microsoft.sqlserver.jdbc.*;

public class connectDS {

   public static void main(String[] args) {

      // Declare the JDBC objects.
      Connection con = null;

      try {
         // Establish the connection. 
         SQLServerDataSource ds = new SQLServerDataSource();
         ds.setUser("UserName");
         ds.setPassword("*****");
         ds.setServerName("localhost");
         ds.setPortNumber(1433); 
         ds.setDatabaseName("AdventureWorks");
         con = ds.getConnection();

      }
      catch (Exception e) {
         e.printStackTrace();
      }
      finally {
         if (con != null) try { con.close(); } catch(Exception e) {}
         System.exit(1);
      }
   }
}