无法创建下列URL的连接:jdbc:microsoft:sqlserver://localhost:40000;DatabaseName=bbs

Question

那位高手帮帮忙啊!  
Thu Nov 22 21:10:40 CST 2007: 成功注册JDBC驱动程序com.microsoft.jdbc.sqlserver.SQLServerDriver
Thu Nov 22 21:10:40 CST 2007: 成功创建连接池mysql
Thu Nov 22 21:10:43 CST 2007: 无法创建下列URL的连接: jdbc:microsoft:sqlserver://localhost:40000;DatabaseName=bbs
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at net.acai.database.DBConnectionManager$DBConnectionPool.newConnection(DBConnectionManager.java:344)
at net.acai.database.DBConnectionManager$DBConnectionPool.getConnection(DBConnectionManager.java:286)
at net.acai.database.DBConnectionManager.getConnection(DBConnectionManager.java:70)
at net.acai.database.DBConnect.init(DBConnect.java:23)
at net.acai.database.DBConnect.<init>(DBConnect.java:46)
at net.acai.forum.ForumPropertiesManager.<init>(ForumPropertiesManager.java:55)
at net.acai.forum.ForumPropertiesManager.getString(ForumPropertiesManager.java:35)
at org.apache.jsp.forum.index_jsp._jspService(index_jsp.java:103)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:834)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:640)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
at java.lang.Thread.run(Thread.java:595)

Answer 1

你是用JDBC连接MS SQL2000吧的驱动吧
端口应该是1433吧
而且有的必须要安装2000 SP3补丁 不然1433也不打不开
其实还有万能的方法，不用JDBC驱动的
记得是在sun公司的网站上一个连接到inet上下一个datasource源包，它可以直接与JDBC上层API创建连接
就是用datasource.getConnection()返回一个连接

Answer 2

Thu   Nov   22   21:10:40   CST   2007:   成功注册JDBC驱动程序com.microsoft.jdbc.sqlserver.SQLServerDriver 
Thu   Nov   22   21:10:40   CST   2007:   成功创建连接池mysql 
Thu   Nov   22   21:10:43   CST   2007:   无法创建下列URL的连接:   jdbc:microsoft:sqlserver://localhost:40000;DatabaseName=bbs 到底什么数据库啊，又是sqlserver驱动又是mysql连接池你把sqlserver的端口改到40000了吗？

Answer 3

java.sql.SQLException:   [Microsoft][SQLServer   2000   Driver   for   JDBC]Error   establishing   socket. 
你绑定SOCKET错了,不是你的连接字符串有问题
1.确定SQL SERVER已经运行
2.确定SQL SERVER的40000端口可以接收外部连接

Answer 4

怎么改SQL Server的端口啊