帮忙看一下下面连接access数据库中问题出在哪了?
<%@ page import="java.lang.*, java.io.*, java.sql.*" contentType="text/html; charset=EUC_CN" %>
<%
out.println(request.getRealPath("userinfo.mdb"));
response.reset();
String strurl="jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=" + request.getRealPath("userinfo.mdb");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(strurl);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * user_info");
if(rs.next())
{
System.out.println(rs.getString("name"));
}
%>
===================
运行后:
javax.servlet.ServletException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified