和数据库连接时No suitable driver 。。
我用的j2sdk1.4.1_03,Tomcat 4.1,Microsoft SQL Server 2000 Driver for JDBC,
这是原码
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://WORKGROU-AE53P0:1433;DatabaseName=zy";
Connection con=DriverManager.getConnection(url);
con.setCatalog("lyb");
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery("select * from lyb");
String name=rs.getString("name");
stmt.close();
con.close();
%>
运行后就是
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
.............................(下面N行省略)
如果把Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
换成Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
的话,动行时就变成:
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: No suitable driver (这句和上面不同)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
...........................(下面都是一样。)
classpath也设了msbase.jar,mssqlserver.jar,msutil.jar的安装路径
我也把msbase.jar,mssqlserver.jar,msutil.jar拷到tomcat4.1\shared\lib下了
sql server2000服务也运行着的。
可就是连不上驱动呐。。。