在近我换了一个系统,重新安装了sql2000也打了sp4补丁,同时用的是tomcat6安装版,SQL2000F老是连接不上.请帮忙
其数据库结构如下:
userID   username
1        a
2        b
3        c
程序运行到con=DriverManager.getConnection("jdbc:odbc:testDB")时出错了!求助:程序运行到con=DriverManager.getConnection("jdbc:odbc:testDB")部分出现错误,请帮忙,
源程序:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<body>
<%
Connection con;
Statement sql;
ResultSet rs;
try
{
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{
 System.out.print("class not find!");
}
try

 con=DriverManager.getConnection("jdbc:odbc:testDB");
System.out.println("aaa");
 sql=con.createStatement();
 rs=sql.executeQuery("SELECT * FROM userTale");
 out.print("<table border>");
 out.print("<tr><td colspan=8 align=center> userDate</td></tr>");
 out.print("<tr>");
  out.print("<td width=100>"+"userID");
  out.print("<td width=50>"+"username");
 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("<tr>");
 }
 out.print("</table>");
 con.close();
}
catch(Exception e2)
{
     e2.printStackTrace();
}
%>
</body>
</html>
运行时在tomcat上出现如下异常:
ava.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]用户 '(nul
l)' 登录失败。原因: 未与信任 SQL Server 连接相关联。
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at org.apache.jsp.jsp1.p43selectUserTable1_jsp._jspService(p43selectUser
Table1_jsp.java:72)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:374)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
37)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:433)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:286)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
7)
        at java.lang.Thread.run(Unknown Source)
可能是数据源找不到,我是换了一个系统,同时在安装sql2000也打了sp4补丁.
我用的tomcat6.0安装版本,在其安装目录中没有"common"文件夹,(有些jsp程序可以正常运行!)
我配置的环境就是如下:
classpath:.;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar;%TOMCAT_HOME%\libjava_home:C:\Program Files\Java\jdk1.6.0_03path:%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SystemRoot%\System32
\Wbem;%java_home%\bin;%java_home%\jre\bin;C:\Program Files\Microsoft SQL Server 2000 Driver 
for JDBC\lib;d:C:\Program Files\Microsoft SQL Server\80\Tools\Binn