connect JDBC with MS Sql2k,but failed

[huanyu zhao]

  
import java.sql.*;  
import javax.sql.*;   
 public class  TestDbConnection{ 
     public static void  main(String args[]){        
// int result = 0;     
 // Connection cnn = null;     
 Statement smt = null;     
 ResultSet rst = null;    
  String requestString = null;    
  try {       
 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); // 
String url= "jdbc:microsoft:sqlserver://localhost:1433";    
Connection conn = DriverManager.getConnection    ("jdbc:microsoft:sqlserver://localhost:1433","sa","");           
         
 System.out.println("u  r greatsuccessfully");    
 }     
 catch(Exception e)
{         
e.printStackTrace();      
 System.out.println("u r failed");   
   }     
   }    
}  

what`s wrong with them?
i have make the path or classpath correctly.
i guess maybe the url is wrong?
[ June 21, 2003: Message edited by: huanyu zhao ]
[ June 21, 2003: Message edited by: huanyu zhao ]

[huanyu zhao]

the result is showed below

  
G:\JBuilder8\jdk1.4\bin\javaw -classpath "
C:\Documents and Settings\huanyu\Desktop\TestDbcONNECTION\classes;
G:\JBuilder8\jdk1.4\jre\lib\rt.jar;
G:\JBuilder8\jdk1.4\jre\lib\i18n.jar;
G:\JBuilder8\jdk1.4\jre\lib\sunrsasign.jar;
G:\JBuilder8\jdk1.4\jre\lib\jsse.jar;
G:\JBuilder8\jdk1.4\jre\lib\jce.jar;
G:\JBuilder8\jdk1.4\jre\lib\charsets.jar;
G:\JBuilder8\jdk1.4\jre\classes;
G:\JBuilder8\jdk1.4\lib\tools.jar"  TestDbConnection  
 java.lang.ClassNotFoundException: 
com.microsoft.jdbc.sqlserver.SQLServerDriver 
   at java.net.URLClassLoader$1.run(URLClassLoader.java:198)   
 at java.security.AccessController.doPrivileged(Native Method)    
at java.net.URLClassLoader.findClass(URLClassLoader.java:186)    
at java.lang.ClassLoader.loadClass(ClassLoader.java:299)   
 at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)    
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)  
  at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)   
 at java.lang.Class.forName0(Native Method)   
 at java.lang.Class.forName(Class.java:140)  
  at TestDbConnection.main(TestDbConnection.java:13)  u r failed 

[ June 21, 2003: Message edited by: huanyu zhao ]
[ June 21, 2003: Message edited by: huanyu zhao ]

[Philip Shanks]

First: I don't see the SQLServer driver in the classpath.
Second: the jdbc URL doesn't point to a specific database (I don't know if this is necessary)
Third: stop using the direct calls to a specific Driver. Use a DataSource object instead to get your Connection object.