<%@ page import="java.sql.*" %>
<%@ page import="sun.jdbc.odbc.JdbcOdbcDriver" %>
<html>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String sourceURL = "jdbc:odbc:TicketRequest";
Connection dc = DriverManager.getConnection(sourceURL,"xiaoyao","woshuai");
out.println("The database connection is " + dc.toString());
%>
</body>
</html>错误:
[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
但是我添加数据源了呀!而且在普通java程序下测试成功,和jsp有什么区别么?
<%@ page import="sun.jdbc.odbc.JdbcOdbcDriver" %>
<html>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String sourceURL = "jdbc:odbc:TicketRequest";
Connection dc = DriverManager.getConnection(sourceURL,"xiaoyao","woshuai");
out.println("The database connection is " + dc.toString());
%>
</body>
</html>错误:
[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
但是我添加数据源了呀!而且在普通java程序下测试成功,和jsp有什么区别么?
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
其中path是数据库文件路径