在近我换了一个系统,重新安装了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
l)' 登录失败。原因: 未与信任 SQL Server 连接相关联。 你是不是没有加用户名和密码啊