java.lang.ClassNotFoundException:com.microsoft.jdbc.sqlserv

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

下面是一个例子，已经封装到函数：

<br> public static Connection linktoSQLServer() {<br> //String connect to SQL server<br> String strServerIPAddress = "localhost";<br> String strDatabaseName = "AdventureWorks";<br> String url = "jdbc:sqlserver://" + strServerIPAddress + ":1433" +";DatabaseName=" + strDatabaseName;<br> String strUserName = "sa";<br> String strPassword = "123456";<br> //Connection cOnn= null;<br> try {<br> // Register the driver<br> Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();<br> try {/* Get a connection to the database */cOnn= DriverManager.getConnection(url, strUserName, strPassword);<br> } catch (SQLException ex) {System.out.println("Exception One:");ex.printStackTrace();<br> }<br> } catch (Exception ex) {<br> System.out.println("Exception Two:");<br> ex.printStackTrace();<br> }<br> System.out.println("Connected...");<br> return conn;<br> }<br> public static void SQLServer_select() {<br> //this code just for SQL Server<br> try {<br> String strCmd = "SELECT * FROM Production.Location";<br> rs = stmt.executeQuery(strCmd);<br> 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));<br> }<br> } catch (SQLException ex) {<br> System.out.println("SQLException: " + ex.getMessage());<br> System.out.println("SQLState: " + ex.getSQLState());<br> System.out.println("VendorError: " + ex.getErrorCode());<br> }<br> }