这个是我连接数据库的jsp文件报错结果
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:673)
org.apache.jsp.TMPiprg5f4xh0_jsp._jspService(TMPiprg5f4xh0_jsp.java:76)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

感觉像是说sa用户名和密码的问题导致连接不上，但是这是再我本机上测试的啊，用户名和密码我都设置的是sa，应该没有问题的啊，我把连接改成用odbc就ok
真晕。

这个是我的bean文件
package test;
import java.sql.*;
public class SQLBean
{
    Connection con=null;
    ResultSet rs=null;
    //实例化，装载JDBC驱动程序
public SQLBean()
{
  try{
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();  
      }
      catch(ClassNotFoundException e) {}
}
//返回查询后的数据集
public ResultSet executeQuery(String sql)
{
     String url="jdbc:microsoft:sqlserver://nbdragon:1433;DatabaseName=test";
        String username="sa";
        String password="sa";
        try{
       con=DriverManager.getConnection(url,username,password);
       Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
       rs=stmt.executeQuery(sql);
     }
     catch(SQLException e) {}
  return rs;
}
//关闭数据库
public void closeDB()
{
  try{
      rs.close();
      con.close();
    }catch(SQLException e) {}
}
}
  

[此贴子已经被作者于2005-4-18 17:29:00编辑过]