这段代码怎么就无法打开数据库呢？
数据库是使用sql server 2000 建立的 怎么就打不开呢？请指点迷津，非常感谢！
<%String name= "sa ",url= "jdbc:odbc:library ";%>
<%name=request.getParameter( "search ");%>
<%String subS= "select * from book where bookname= ' "+name+ " ' ";%>
<div align= "center "> <hr>
<%try{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");
Connection con=DriverManager.getConnection(url, "sa ", " ");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(subS);
if(rs.next())
...
...

[解决办法]
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ").newInstance();
String url= "jdbc:microsoft: sqlserver:// "数据库地址IP ":1433;DatabaseName=pubs ";