<%@page contentType="text/html; charset=GBK" import="java.sql.*"%>
<html>
<head>
<title>jsp2</title>
</head>
<body bgcolor="#ffffff">
<% try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String dburl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=test.mdb"; Connection conn = DriverManager.getConnection(dburl);
Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("select * from T1");
String tmp = "";
while (rs.next()) {
tmp = rs.getString("MTV");
}
System.out.println(tmp);
session.setAttribute("path",tmp);
rs.close();
stmt.close();
conn.close();
}
catch(Exception ex) {
out.println("Error "+ex.getMessage());
}%>
</body>
</html>在JB的环境下。
会出现以下错误。。Error [Microsoft][ODBC Microsoft Access Driver] 找不到文件 '(未知的)'。
<html>
<head>
<title>jsp2</title>
</head>
<body bgcolor="#ffffff">
<% try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String dburl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=test.mdb"; Connection conn = DriverManager.getConnection(dburl);
Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("select * from T1");
String tmp = "";
while (rs.next()) {
tmp = rs.getString("MTV");
}
System.out.println(tmp);
session.setAttribute("path",tmp);
rs.close();
stmt.close();
conn.close();
}
catch(Exception ex) {
out.println("Error "+ex.getMessage());
}%>
</body>
</html>在JB的环境下。
会出现以下错误。。Error [Microsoft][ODBC Microsoft Access Driver] 找不到文件 '(未知的)'。
================================================== 不是说找不到文件了么?
环境变量中classpath指定到 把这个odbc对应的 jar 。