曉風殘月
          
		新手上路
	
          

          
          		
	

          

          


          
	
		
          
			


          
posts - 6,comments - 49,trackbacks - 0


          
	

          


          
	
					


          
	
	
		
          使用MS Sql2000 for JDBC SP3連接MS Sql2000出現如下錯誤：
          
		
          
				
				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(Unknown?Source)
          ????at?java.sql.DriverManager.getConnection(Unknown?Source)
          ????at?drawServlet.doGet(drawServlet.java:          
				50
				)
          ????at?drawServlet.doPost(drawServlet.java:          
				18
				)
          ????at?javax.servlet.http.HttpServlet.service(HttpServlet.java:          
				709
				)
          ????at?javax.servlet.http.HttpServlet.service(HttpServlet.java:          
				802
				)
          ????at?org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:          
				237
				)
          ????at?org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:          
				157
				)
          ????at?org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:          
				214
				)
          ????at?org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:          
				104
				)
          ????at?org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:          
				520
				)
          ????at?org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:          
				198
				)
          ????at?org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:          
				152
				)
          ????at?org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:          
				104
				)
          ????at?org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:          
				520
				)
          ????at?org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:          
				137
				)
          ????at?org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:          
				104
				)
          ????at?org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:          
				118
				)
          ????at?org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:          
				102
				)
          ????at?org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:          
				520
				)
          ????at?org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:          
				109
				)
          ????at?org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:          
				104
				)
          ????at?org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:          
				520
				)
          ????at?org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:          
				929
				)
          ????at?org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:          
				160
				)
          ????at?org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:          
				799
				)
          ????at?org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:          
				705
				)
          ????at?org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:          
				577
				)
          ????at?org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:          
				683
				)
          ????at?java.lang.Thread.run(Unknown?Source)
          java.sql.SQLException:?          
				[
				Microsoft
				][
				SQLServer?2000?Driver?for?JDBC
				]
				End?of?stream?was?detected?on?a?read.
          ????at?com.microsoft.jdbc.base.BaseExceptions.createException(Unknown?Source)
          ????at?com.microsoft.jdbc.base.BaseExceptions.getException(Unknown?Source)
          ????at?com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(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(Unknown?Source)
          ????at?java.sql.DriverManager.getConnection(Unknown?Source)
          ????at?drawServlet.doGet(drawServlet.java:          
				92
				)
          ????at?drawServlet.doPost(drawServlet.java:          
				18
				)
          ????at?javax.servlet.http.HttpServlet.service(HttpServlet.java:          
				709
				)
          ????at?javax.servlet.http.HttpServlet.service(HttpServlet.java:          
				802
				)
          ????at?org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:          
				237
				)
          ????at?org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:          
				157
				)
          ????at?org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:          
				214
				)
          ????at?org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:          
				104
				)
          ????at?org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:          
				520
				)
          ????at?org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:          
				198
				)
          ????at?org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:          
				152
				)
          ????at?org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:          
				104
				)
          ????at?org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:          
				520
				)
          ????at?org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:          
				137
				)
          ????at?org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:          
				104
				)
          ????at?org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:          
				118
				)
          ????at?org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:          
				102
				)
          ????at?org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:          
				520
				)
          ????at?org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:          
				109
				)
          ????at?org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:          
				104
				)
          ????at?org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:          
				520
				)
          ????at?org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:          
				929
				)
          ????at?org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:          
				160
				)
          ????at?org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:          
				799
				)
          ????at?org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:          
				705
				)
          ????at?org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:          
				577
				)
          ????at?org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:          
				683
				)
          ????at?java.lang.Thread.run(Unknown?Source)          
		
          
		
          原因：由于開發環境是Win 2003 Server，故SQL 2000需要補丁包，不然在2k3下，SQL默認關閉了TCP連接
          解決：打上SQL serverSP4 就OK了?
	
          posted on 2006-06-10 15:35 jinglecat 閱讀(22214) 評論(41)  編輯  收藏  所屬分類: Java Prime 
          

          







          
	    
    


          
FeedBack:

          
	

		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2006-10-26 09:04 | cenqin
          
				
          我已經打上了sp4包還是錯誤。

          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 org.apache.jsp.chap3_002d1_jsp._jspService(org.apache.jsp.chap3_002d1_jsp:63)

          	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)

          	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

          	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)

          	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)

          	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)

          	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

          	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

          	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

          	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

          	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

          	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

          	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

          	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

          	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

          	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)

          	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)

          	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

          	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

          	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

          	at java.lang.Thread.run(Thread.java:595)

          請高手指點，謝謝  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2006-10-27 16:04 | jinglecat
          
				
          @cenqin

          也許你應該確認你的連接字符串是否正確。

          我確實是通過打上SP4，解決了此問題。

          PS：我只是個Java新手，到CSDN的Java社區看看或許有其他網友有類似問題。

            回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2006-10-27 16:41 | jinglecat
          
				
          @cenqin

          不知道你裝的什么系統，打上

          Microsoft SQL Server 2000 Driver for JDBC Service Pack 3

          試試

          http://www.microsoft.com/sql/downloads上有得下  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄]
          
			
          
				2007-07-25 00:09 | 呵呵
          
				
          我用的是XP系統,也出現了和上面一樣的錯誤啊,

          

          應該怎么解決?  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄]
          
			
          
				2007-07-25 18:23 | jinglecat
          
				
          @呵呵

          裝 SQL Server sp4 看看  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2007-09-15 23:35 | lean
          
				
          我也遇到類似的問題了

          而且SQL2000補丁SP4也打了

          哪位高手能幫忙解決

          我的E-Mail :jolin86967@163.com  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄]
          
			
          
				2007-09-26 00:25 | yuan
          
				
          我也是遇到這樣的問題，我也按照大家說的方法去做了，可問題還是得不到解決也，急請高手幫忙解決下哈~~~~~~~~~~~~~~~  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2007-09-28 09:26 | QQ47399056
          
				
          換mysql吧  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄]
          
			
          
				2007-10-09 11:43 | 逍遙
          
				
          把SQL登陸模式改為混合登陸模式就好了。呵呵！

          QQ：80764911  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2007-10-31 14:51 | quweihua
          
				
          [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(Unknown Source)

          	at java.sql.DriverManager.getConnection(Unknown Source)

          	at org.apache.jsp.index_jsp._jspService(index_jsp.java:63)

          	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:393)

          	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)

          	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(ApplicationFilterChain.java:290)

          	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

          	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)

          	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)

          	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

          	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)

          	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

          	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)

          	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)

          	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)

          	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

          	at java.lang.Thread.run(Unknown Source)

          2007-10-31 14:39:43 org.apache.catalina.core.StandardWrapperValve invoke

          嚴重: Servlet.service() for servlet jsp threw exception

          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(Unknown Source)

          	at java.sql.DriverManager.getConnection(Unknown Source)

          	at org.apache.jsp.index_jsp._jspService(index_jsp.java:63)

          	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:393)

          	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)

          	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(ApplicationFilterChain.java:290)

          	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

          	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)

          	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)

          	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

          	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)

          	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

          	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)

          	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)

          	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)

          	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

          	at java.lang.Thread.run(Unknown Source)

          我用的是Xp系統，裝的sqlserver personal個人版的  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2008-05-06 10:33 | lizhaofeng
          
				
          我用的是eclipse 

          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(Unknown Source)

          	at java.sql.DriverManager.getConnection(Unknown Source)

          請那位大俠幫我解決一下，謝謝

          我的E-mail 是xiaozhao1795@163.com  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2008-05-18 13:38 | jeremy
          
				
          就沒個高手出來解決下？在網上溜達了1個月了，這個問題的帖子幾乎都是沒有解決方案的哦·······················  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2008-05-23 13:59 | w9413
          
				
          哎,我也是這樣的錯誤,N天了,什么SP3,我連SP4的補丁都打上去了,更奇怪的有的時候可以連上,在公司連上就沒問題,回家之后,無論怎么連,怎么改都不行,第二天一來公司,很正常.我斗郁悶的很,也不知道問題出在哪的,現在連本地的怎么連都連不上,通過IP地址連到別人的數據庫很正常,查詢分析器可以查出來.哭都哭不好!

             有誰趕快解決啊  ,多謝多謝!  有誰解決好了,加我QQ65369534,告訴我一下什么問題,謝謝了 .  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2008-07-22 19:25 | sssss
          
				
          @jinglecat

          我有個辦法，不用架包能連的，

          new sun.jdbc.odbc.JdbcOdbcDriver();

          Connection=java.sql.DriverManager.getConnection("jdbc:odbc:Driver={sql server};server=.;database=數據庫名);  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2008-07-28 16:08 | yumen
          
				
          關注中~~  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2008-08-01 17:34 | werw
          
				
          @sssss

          werw  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2008-08-01 17:44 | werwtryrty
          
				
          @sssss

          tryrty  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2008-08-04 14:01 | 郁悶啊
          
				
          我也是。。。。怎么辦呢，都打了SP4補丁了，而且也設置了環境變量了，發布到tomcat下了，還是不行啊  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2008-08-04 14:02 | 郁悶啊
          
				
          哪個高手指導下啊！感激不盡，我的郵箱wanfeng20088@163.com  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄]
          
			
          
				2008-09-02 10:43 | feng
          
				
          我頁遇到這個問題，哪個高手能給講下為什么會出現這個異常。我的XP系統，驗證模式時混合的，用查詢分析器也能進入，我還是自己建的數據庫。自己創建的登陸用戶。就時出現那個異常怎么弄頁弄不好，希望高手給指點下。oyxl520@163.com 

          QQ:414362883  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2009-02-04 20:09 | 哭了
          
				
          我也打了sp4了 而且是混合模式 可還是

          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(Unknown Source)

          	at java.sql.DriverManager.getConnection(Unknown Source)

          

          哭死了  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2009-02-04 20:12 | 哭了
          
				
          我的密碼設為空了 這不是問題吧 

          求助高手啊

          我的 email是liang_aijing@yeah.net  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2009-02-25 17:27 | 我裝的明明就是2005卻出現那個問題
          
				
          我明明就裝的視2005，沒有2000啊！

          為什么用Java純連接的時候還出現Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket這個問題啊？  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2009-03-02 12:38 | 為何
          
				
          我的是xp，也是這個問題。微軟太惡心了。  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2009-03-18 19:05 | agui2007
          
				
          打上sp4的補丁就好了

          還有打補丁時要注意，exe文件是解壓縮還要自己雙擊setup的  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2009-04-11 00:47 | 真bt的問題呀
          
				
          我SP3  SP4  ，SQLServer 2000 JDBC驅動裝了  環境變量設了

          三個包也導入了   在eclipse里面和MyEclipse里面都不能連接成功！

          這段時間把頭都搞大了   煩呀！

          有哪個高手能幫我解決的  聯系我呀！十分感謝

          qq：466651088

          email：ken2008huang@126.com

          感謝大家了！  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2009-04-15 10:03 | 梁瑞芳
          
				
          java.lang.NullPointerException

          	at dao.achieve.DBConnection.getResult(DBConnection.java:51)

          	at dao.achieve.DBUserAccountOpImp.getFriendList(DBUserAccountOpImp.java:285)

          	at GetFriendList.doPost(GetFriendList.java:38)

          	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)

          	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

          	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:172)

          	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:174)

          	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)

          	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

          	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

          	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

          	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

          	at java.lang.Thread.run(Unknown Source)

          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(Unknown Source)

          	at java.sql.DriverManager.getConnection(Unknown Source)

          	at dao.achieve.DBConnection.<init>(DBConnection.java:18)

          	at dao.achieve.DBUserAccountOpImp.<init>(DBUserAccountOpImp.java:17)

          	at dao.factory.DB_OPFactory.getDBUserOP(DB_OPFactory.java:10)

          	at GetFriendList.doPost(GetFriendList.java:36)

          	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)

          	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

          	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:172)

          	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:174)

          	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)

          	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

          	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

          	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

          	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

          	at java.lang.Thread.run(Unknown Source)

          2009-4-15 9:35:39 org.apache.catalina.core.StandardWrapperValve invoke  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄]
          
			
          
				2009-04-21 20:09 | sam
          
				
          是啊，請高手幫忙一下，小弟也遇到這樣的問題，sp4補丁裝上了，但是就是連接不了  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄]
          
			
          
				2009-04-26 19:26 | 菜鳥
          
				
          我用的SQL2005和MyEclipse連接，在學校連的上到自己的機器上也出現和上面一樣的問題，急死人了哎，哪個高手幫忙下QQ：691259685。感激不盡！！！  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄]
          
			
          
				2009-04-27 22:28 | 菜鳥
          
				
          課能是出現這樣的問題！！我也不是很清楚，我是這樣解決的.

          -----連接出現的問題

          private static final String DRIVER="com.microsoft.jdbc.sqlserver.SQLServerDriver";       private static final String URL="jdbc:microsoft:sqlsever://localhost:1433;databasename=數據庫的名稱";

          	private static final String DBNAME="sa";

          	private static final String DBPASS="sa";

          	public static Connection getConn() throws ClassNotFoundException, SQLException

          	{

          		Connection conn=null;

          		Class.forName(DRIVER);

          		conn=DriverManager.getConnection(URL,DBNAME,DBPASS);

          		return conn;

          	}

          這里的DBNAME和DBPASS不能為空，應為MYCLIPSE和SQL的連接只能和sql身份驗證的用戶名和密碼才能正確的連接。和WINDOWS的身份驗證連接不行。呵呵這是我的理解，我也解決了這個問題，希望大家幫我看看，希望給出建議。  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2009-04-28 21:25 | carol.haul
          
				
          @sssss

          你的方法我試了，很管用，謝謝，一直困擾我多日的問題終于解決了，真的謝謝你~  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2009-07-24 14:43 | 為
          
				
          這些方法我都試了，還是不行  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄]
          
			
          
				2009-07-26 23:47 | l
          
				
          sql的兩種方式windows和sql是否都能連接上sqlserver  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2009-08-23 08:48 | xiu
          
				
          是不是端口的問題啊，我跟大家一樣的情況。剛發現TCP端口寫錯了，在服務器端和客戶端網絡實用工具中設置一樣的端口，在程序中連接數據庫的時候也對應一樣就可以了，我的是這樣解決的  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2010-04-20 22:42 | 網管軟件
          
				
          在命令窗口執行Netstat -a -b 查看有沒有sqlsvr.exe占用端口,如果沒有在用SQLServer企業管理器中數據庫的屬性設置網絡參數,把TCP/IP協議啟用 端口為1433  上面的問題大都是這個原因.  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄]
          
			
          
				2010-12-20 22:46 | h
          
				
           [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:582)

          	at java.sql.DriverManager.getConnection(DriverManager.java:185)

          	at com.wsy.dao.Dao.<init>(Dao.java:35)

          	at com.wsy.dao.Dao.executeQuery(Dao.java:47)

          	at com.wsy.dao.Dao.check(Dao.java:87)

          	at com.wsy.iframe.BookLoginIFrame$BookLoginAction.actionPerformed(BookLoginIFrame.java:40)

          	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)

          	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)

          	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)

          	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)

          	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)

          	at java.awt.Component.processMouseEvent(Component.java:6216)

          	at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)

          	at java.awt.Component.processEvent(Component.java:5981)

          	at java.awt.Container.processEvent(Container.java:2041)

          	at java.awt.Component.dispatchEventImpl(Component.java:4583)

          	at java.awt.Container.dispatchEventImpl(Container.java:2099)

          	at java.awt.Component.dispatchEvent(Component.java:4413)

          	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556)

          	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220)

          	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150)

          	at java.awt.Container.dispatchEventImpl(Container.java:2085)

          	at java.awt.Window.dispatchEventImpl(Window.java:2475)

          	at java.awt.Component.dispatchEvent(Component.java:4413)

          	at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)

          	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)

          	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)

          	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)

          	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)

          	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)

          	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

          Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException

          	at com.wsy.dao.Dao.executeQuery(Dao.java:48)

          	at com.wsy.dao.Dao.check(Dao.java:87)

          	at com.wsy.iframe.BookLoginIFrame$BookLoginAction.actionPerformed(BookLoginIFrame.java:40)

          	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)

          	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)

          	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)

          	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)

          	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)

          	at java.awt.Component.processMouseEvent(Component.java:6216)

          	at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)

          	at java.awt.Component.processEvent(Component.java:5981)

          	at java.awt.Container.processEvent(Container.java:2041)

          	at java.awt.Component.dispatchEventImpl(Component.java:4583)

          	at java.awt.Container.dispatchEventImpl(Container.java:2099)

          	at java.awt.Component.dispatchEvent(Component.java:4413)

          	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556)

          	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220)

          	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150)

          	at java.awt.Container.dispatchEventImpl(Container.java:2085)

          	at java.awt.Window.dispatchEventImpl(Window.java:2475)

          	at java.awt.Component.dispatchEvent(Component.java:4413)

          	at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)

          	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)

          	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)

          	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)

          	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)

          	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)

          	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

          我是用myeclipse運行的，我什么辦法都試過了，希望那位高手幫我解決一下  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2011-01-11 18:03 | 錢宇皓
          
				
          我的是XP系統裝SQL2005也是出現上述問題！！跪求高手幫助！！郵箱qq429626538@163.com  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2011-03-12 16:46 | ltsznh
          
				
          其實問題也許很簡單，檢查下防火墻是不是開著呢，關閉->搞定  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2012-03-29 14:04 | 大道
          
				
          @jinglecat
            回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          
			
          
				2012-03-29 14:13 | o2o
          
				
          汗，慢慢研究  回復  更多評論
            
          
			
          
			
			
		
          
	
		
          
			
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄]
          
			
          
				2012-09-04 21:28 | 123
          
				
          同出現這個問題，上面的都試過不行，求解決方案！！！297020949@qq.com  回復  更多評論
            
          
			
          
			
			
		
          
	








          








          

				

          



    







          
        
	




主站蜘蛛池模板：
舒城县|
宜君县|
高雄市|
乌拉特前旗|
化州市|
观塘区|
沈阳市|
台安县|
铁岭市|
朔州市|
日喀则市|
平远县|
禹城市|
姜堰市|
巴林左旗|
玉龙|
天等县|
镶黄旗|
竹山县|
石柱|
高陵县|
冀州市|
威宁|
陈巴尔虎旗|
瓦房店市|
阳新县|
巧家县|
若尔盖县|
喀喇|
香河县|
阳曲县|
樟树市|
巴中市|
项城市|
尉氏县|
龙南县|
通州市|
赞皇县|
广元市|
连云港市|
崇仁县|