sql server 2000 jdbc driver使用：com.microsoft.jdbc.sqlserver.sqlserverdriver sql server 2005 and 2008 jdbc drive使用： com.microsoft.sqlserver.jdbc.sqlserverdriver 而且url prefix也从jdbc:microsoft:sqlserver://改为 jdbc:sqlserver:/
sql server 2000 jdbc driver使用：com.microsoft.jdbc.sqlserver.sqlserverdriver
sql server 2005 and 2008 jdbc drive使用：com.microsoft.sqlserver.jdbc.sqlserverdriver
而且url prefix也从jdbc:microsoft:sqlserver://改为jdbc:sqlserver://了。
from:http://blogs.msdn.com/jdbcteam/archive/2007/06/15/java-lang-classnotfoundexception-com-microsoft-jdbc-sqlserver-sqlserverdriver.aspx
下面是一个例子，已经封装到函数：
public static connection linktosqlserver() { //string connect to sql server string strserveripaddress = localhost; string strdatabasename = adventureworks; string url = jdbc:sqlserver:// + strserveripaddress + :1433 + ;databasename= + strdatabasename; string strusername = sa; string strpassword = 123456; //connection conn = null; try { // register the driver class.forname(com.microsoft.sqlserver.jdbc.sqlserverdriver).newinstance(); try { /* get a connection to the database */ conn = drivermanager.getconnection(url, strusername, strpassword); } catch (sqlexception ex) { system.out.println(exception one:); ex.printstacktrace(); } } catch (exception ex) { system.out.println(exception two:); ex.printstacktrace(); } system.out.println(connected...); return conn; } public static void sqlserver_select() { //this code just for sql server try { string strcmd = select * from production.location; rs = stmt.executequery(strcmd); while (rs.next()) { system.out.println(column 1 has value: + rs.getstring(1)); system.out.println(column 2 has value: + rs.getstring(2)); system.out.println(column 3 has value: + rs.getstring(3)); } } catch (sqlexception ex) { system.out.println(sqlexception: + ex.getmessage()); system.out.println(sqlstate: + ex.getsqlstate()); system.out.println(vendorerror: + ex.geterrorcode()); } }