title: how to do jdbc connection with sqlserver2000?
body: <p>here is the code</p>
  
  <pre><code>import java.*;
  public class Connect{
       private java.sql.Connection  con = null;
       private final String url = "jdbc:microsoft:sqlserver://";
       private final String serverName= "localhost";
       private final String portNumber = "1433";
       private final String databaseName= "pubs";
       private final String userName = "user";
       private final String password = "password";
       // Informs the driver to use server a side-cursor, 
       // which permits more than one active statement 
       // on a connection.
       private final String selectMethod = "cursor"; 
  
       // Constructor
       public Connect(){}
  
       private String getConnectionUrl(){
            return 
  
  url+serverName+":"+portNumber+";databaseName="+databaseName+";selectMethod="+selectM
  
  ethod+";";
       }
  
       private java.sql.Connection getConnection(){
            try{
                 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
                 con = 
  
  java.sql.DriverManager.getConnection(getConnectionUrl(),userName,password);
                 if(con!=null) System.out.println("Connection Successful!");
            }catch(Exception e){
                 e.printStackTrace();
                 System.out.println("Error Trace in getConnection() : " + 
  
  e.getMessage());
           }
            return con;
        }
  
       /*
            Display the driver properties, database details 
       */ 
  
       public void displayDbProperties(){
            java.sql.DatabaseMetaData dm = null;
            java.sql.ResultSet rs = null;
            try{
                 con= this.getConnection();
                 if(con!=null){
                      dm = con.getMetaData();
                      System.out.println("Driver Information");
                      System.out.println("\tDriver Name: "+ dm.getDriverName());
                      System.out.println("\tDriver Version: "+ dm.getDriverVersion 
  
  ());
                      System.out.println("\nDatabase Information ");
                      System.out.println("\tDatabase Name: "+ 
  
  dm.getDatabaseProductName());
                      System.out.println("\tDatabase Version: "+ 
  
  dm.getDatabaseProductVersion());
                      System.out.println("Avalilable Catalogs ");
                      rs = dm.getCatalogs();
                      while(rs.next()){
                           System.out.println("\tcatalog: "+ rs.getString(1));
                      } 
                      rs.close();
                      rs = null;
                      closeConnection();
                 }else System.out.println("Error: No active Connection");
            }catch(Exception e){
                 e.printStackTrace();
            }
            dm=null;
       }     
  
       private void closeConnection(){
            try{
                 if(con!=null)
                      con.close();
                 con=null;
            }catch(Exception e){
                 e.printStackTrace();
            }
       }
       public static void main(String[] args) throws Exception
         {
            Connect myDbTest = new Connect();
            myDbTest.displayDbProperties();
         }
  }
  </code></pre>
  
  <p>i have installed "c:\program files\microsoft sql server 2000 driver for JDBC"</p>
  
  <p>compiled as:</p>
  
  <pre><code>C:\Program Files\Java\jdk1.7.0\bin&gt;javac -classpath "c:\program files\Microsoft
  SQL Server 2000 Driver for JDBC\lib\msbase.jar;c:\program files\Microsoft SQL Se
  rver 2000 Driver for JDBC\lib\msutil.jar;c:\program files\Microsoft SQL Server 2
  000 Driver for JDBC\lib\mssqlserver.jar" Connect.java
  </code></pre>
  
  <p>runned as:</p>
  
  <pre><code>C:\Program Files\Java\jdk1.7.0\bin&gt;java -classpath "c:\program files\Microsoft S
  QL Server 2000 Driver for JDBC\lib\msbase.jar;c:\program files\Microsoft SQL Ser
  ver 2000 Driver for JDBC\lib\msutil.jar;c:\program files\Microsoft SQL Server 20
  00 Driver for JDBC\lib\mssqlserver.jar" Connect
  </code></pre>
  
  <p>i get the following output:</p>
  
  <pre><code>Error: Could not find or load main class Connect
  </code></pre>
  
  <p>i could not find out the cause of this error? how to solve this?</p>