<rt id="bn8ez"></rt>
<label id="bn8ez"></label>
  • 

    • <span id="bn8ez"></span>
    

    <label id="bn8ez"><meter id="bn8ez"></meter></label>
    

    
    

    




    







												


        


    

    
	
	


    
	
    
		曉風殘月
    
		新手上路
	
    

    
    		
	

    

    


    
	
		
    
			


    
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 閱讀(22212) 評論(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  回復  更多評論
      
    
			
    
			
			
		
    
	








    








    

				

    



    







    
        
	



主站蜘蛛池模板：
国产亚洲精久久久久久无码AV|
精品久久久久国产免费|
亚洲综合熟女久久久30p|
免费看一级一级人妻片|
亚洲国产精品激情在线观看|
免费人成大片在线观看播放电影|
免费一级一片一毛片|
日韩一区二区三区免费播放|
亚洲一区二区三区免费|
美女视频黄是免费的网址|
亚洲性色成人av天堂|
免费人成在线视频|
亚洲国产成人手机在线观看|
亚洲成a人在线看天堂无码|
日韩在线观看视频免费|
国产精品亚洲а∨无码播放|
久久久久国产免费|
亚洲成人福利网站|
国产成人青青热久免费精品|
fc2免费人成在线视频|
亚洲天堂中文字幕|
成人免费无码视频在线网站|
在线精品自拍亚洲第一区|
国产亚洲av人片在线观看|
97青青草原国产免费观看|
亚洲精品人成网在线播放影院|
国产在线观看免费不卡|
A片在线免费观看|
一区二区亚洲精品精华液|
亚洲一区二区三区免费|
18女人毛片水真多免费|
国产亚洲精品美女2020久久
|
两个人看的www高清免费视频
|
久久久久亚洲AV无码专区网站|
无码人妻一区二区三区免费看
|
精品女同一区二区三区免费播放|
在线a亚洲v天堂网2019无码|
亚洲一级免费毛片|
一道本在线免费视频|
亚洲资源最新版在线观看|
77777亚洲午夜久久多人|