页面上只显示:
java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
tomcat6,sqlserver2000,数据源已经配置并且测试成功,其它不连接数据库的JSP程序可以正常运行对着书看了半天,没发现哪儿不一样啊?咋就不行了呢?鹅滴神啊!谁来帮帮我啊!源代码:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<html><body bgcolor=cyan>
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{ out.print(e);
}
try{
con=DriverManager.getConnection("jdbc:odbc:mymoon","sa","sa");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM employee WHERE salary>3000");
out.print("<table border=2>");
out.print("<tr>");
out.print("<th width=100>"+"雇员号");
out.print("<th width=100>"+"姓名");
out.print("<th width=50>"+"出生日期");
out.print("<th width=50>"+"薪水");
out.print("</TR>");
while(rs.next())
{
out.print("<tr>");
out.print("<td>"+rs.getString(1)+"</td>");
out.print("<td>"+rs.getString(2)+"</td>");
out.print("<td>"+rs.getDate("birthday")+"</td>");
out.print("<td>"+rs.getFloat("salary")+"</td>");
out.print("</tr>");
}
out.print("</table>");
con.close();
}
catch(SQLException e)
{ out.print(e);
}
%></body></html>
java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
tomcat6,sqlserver2000,数据源已经配置并且测试成功,其它不连接数据库的JSP程序可以正常运行对着书看了半天,没发现哪儿不一样啊?咋就不行了呢?鹅滴神啊!谁来帮帮我啊!源代码:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<html><body bgcolor=cyan>
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{ out.print(e);
}
try{
con=DriverManager.getConnection("jdbc:odbc:mymoon","sa","sa");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM employee WHERE salary>3000");
out.print("<table border=2>");
out.print("<tr>");
out.print("<th width=100>"+"雇员号");
out.print("<th width=100>"+"姓名");
out.print("<th width=50>"+"出生日期");
out.print("<th width=50>"+"薪水");
out.print("</TR>");
while(rs.next())
{
out.print("<tr>");
out.print("<td>"+rs.getString(1)+"</td>");
out.print("<td>"+rs.getString(2)+"</td>");
out.print("<td>"+rs.getDate("birthday")+"</td>");
out.print("<td>"+rs.getFloat("salary")+"</td>");
out.print("</tr>");
}
out.print("</table>");
con.close();
}
catch(SQLException e)
{ out.print(e);
}
%></body></html>
需要把sql server jdbc驱动包拷贝到WEB-INF/lib目录
2.检查你的数据库名是否正确及登录的用户名和密码是否正确
3.是否安装数据库的SP4补丁
看一楼的另建议还是直接用jdbc吧
http://hi.baidu.com/kr1423/blog/item/56371524704a9436c9955912.html
可以到这里看下!
mymoon是你配置的数据源名称而不是数据库名称
本来就是配系统DSN啊呵呵,解决了就好。。