通常用
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

如果想连MSSQL SERVER上的数据库，谁能告诉我它的driver名称是什么？网上找也找不到

还有这个数据库的路径怎么写的？

谢谢谢谢谢谢谢谢谢谢谢谢谢谢谢谢谢谢谢谢谢谢

though it is not that effecient...
but it is a solution

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

的数据源及其权限

<%@ page import = "java.sql.*" %>

<%
String url = "jdbc:odbc:mysql";
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
try{
Class.forName(driver);
java.sql.Connection conn = DriverManager.getConnection(url,"wushilin","******");
Statement s = conn.createStatement();
s.executeUpdate("insert into test values('asdf')");
ResultSet rs = s.executeQuery("select * from test");
while(rs.next())
{
out.println(rs.getString(1)+"<br>");
}
rs.close();
s.close();
conn.close();
}
catch(Exception e)
{
System.err.println("Error");
}
%>






output：
test
test
test
asdf
asdf
asdf
asdf

jdk1.3.0

but i think i need to download ms sql jdbc driver instead

search for "JDBC" and you will find the driver