posts - 6,comments - 49,trackbacks - 0

          使用MS Sql2000 for JDBC SP3連接MS Sql2000出現(xiàn)如下錯(cuò)誤:

          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)

          原因:由于開(kāi)發(fā)環(huán)境是Win 2003 Server,故SQL 2000需要補(bǔ)丁包,不然在2k3下,SQL默認(rèn)關(guān)閉了TCP連接
          解決:打上SQL serverSP4 就OK了?
          posted on 2006-06-10 15:35 jinglecat 閱讀(22214) 評(píng)論(41)  編輯  收藏 所屬分類: Java Prime

          FeedBack:
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2006-10-26 09:04 | cenqin
          我已經(jīng)打上了sp4包還是錯(cuò)誤。
          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)
          請(qǐng)高手指點(diǎn),謝謝  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2006-10-27 16:04 | jinglecat
          @cenqin
          也許你應(yīng)該確認(rèn)你的連接字符串是否正確。
          我確實(shí)是通過(guò)打上SP4,解決了此問(wèn)題。
          PS:我只是個(gè)Java新手,到CSDN的Java社區(qū)看看或許有其他網(wǎng)友有類似問(wèn)題。
            回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2006-10-27 16:41 | jinglecat
          @cenqin
          不知道你裝的什么系統(tǒng),打上
          Microsoft SQL Server 2000 Driver for JDBC Service Pack 3
          試試
          http://www.microsoft.com/sql/downloads上有得下  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄](méi)
          2007-07-25 00:09 | 呵呵
          我用的是XP系統(tǒng),也出現(xiàn)了和上面一樣的錯(cuò)誤啊,

          應(yīng)該怎么解決?  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄](méi)
          2007-07-25 18:23 | jinglecat
          @呵呵
          裝 SQL Server sp4 看看  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2007-09-15 23:35 | lean
          我也遇到類似的問(wèn)題了
          而且SQL2000補(bǔ)丁SP4也打了
          哪位高手能幫忙解決
          我的E-Mail :jolin86967@163.com  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄](méi)
          2007-09-26 00:25 | yuan
          我也是遇到這樣的問(wèn)題,我也按照大家說(shuō)的方法去做了,可問(wèn)題還是得不到解決也,急請(qǐng)高手幫忙解決下哈~~~~~~~~~~~~~~~  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2007-09-28 09:26 | QQ47399056
          換mysql吧  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄](méi)
          2007-10-09 11:43 | 逍遙
          把SQL登陸模式改為混合登陸模式就好了。呵呵!
          QQ:80764911  回復(fù)  更多評(píng)論
            
          # 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
          嚴(yán)重: 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系統(tǒng),裝的sqlserver personal個(gè)人版的  回復(fù)  更多評(píng)論
            
          # 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)
          請(qǐng)那位大俠幫我解決一下,謝謝
          我的E-mail 是xiaozhao1795@163.com  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2008-05-18 13:38 | jeremy
          就沒(méi)個(gè)高手出來(lái)解決下?在網(wǎng)上溜達(dá)了1個(gè)月了,這個(gè)問(wèn)題的帖子幾乎都是沒(méi)有解決方案的哦·······················  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2008-05-23 13:59 | w9413
          哎,我也是這樣的錯(cuò)誤,N天了,什么SP3,我連SP4的補(bǔ)丁都打上去了,更奇怪的有的時(shí)候可以連上,在公司連上就沒(méi)問(wèn)題,回家之后,無(wú)論怎么連,怎么改都不行,第二天一來(lái)公司,很正常.我斗郁悶的很,也不知道問(wèn)題出在哪的,現(xiàn)在連本地的怎么連都連不上,通過(guò)IP地址連到別人的數(shù)據(jù)庫(kù)很正常,查詢分析器可以查出來(lái).哭都哭不好!
          有誰(shuí)趕快解決啊 ,多謝多謝! 有誰(shuí)解決好了,加我QQ65369534,告訴我一下什么問(wèn)題,謝謝了 .  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2008-07-22 19:25 | sssss
          @jinglecat
          我有個(gè)辦法,不用架包能連的,
          new sun.jdbc.odbc.JdbcOdbcDriver();
          Connection=java.sql.DriverManager.getConnection("jdbc:odbc:Driver={sql server};server=.;database=數(shù)據(jù)庫(kù)名);  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2008-07-28 16:08 | yumen
          關(guān)注中~~  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2008-08-01 17:34 | werw
          @sssss
          werw  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2008-08-01 17:44 | werwtryrty
          @sssss
          tryrty  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2008-08-04 14:01 | 郁悶啊
          我也是。。。。怎么辦呢,都打了SP4補(bǔ)丁了,而且也設(shè)置了環(huán)境變量了,發(fā)布到tomcat下了,還是不行啊  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2008-08-04 14:02 | 郁悶啊
          哪個(gè)高手指導(dǎo)下啊!感激不盡,我的郵箱wanfeng20088@163.com  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄](méi)
          2008-09-02 10:43 | feng
          我頁(yè)遇到這個(gè)問(wèn)題,哪個(gè)高手能給講下為什么會(huì)出現(xiàn)這個(gè)異常。我的XP系統(tǒng),驗(yàn)證模式時(shí)混合的,用查詢分析器也能進(jìn)入,我還是自己建的數(shù)據(jù)庫(kù)。自己創(chuàng)建的登陸用戶。就時(shí)出現(xiàn)那個(gè)異常怎么弄頁(yè)弄不好,希望高手給指點(diǎn)下。oyxl520@163.com
          QQ:414362883  回復(fù)  更多評(píng)論
            
          # 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)

          哭死了  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2009-02-04 20:12 | 哭了
          我的密碼設(shè)為空了 這不是問(wèn)題吧
          求助高手啊
          我的 email是liang_aijing@yeah.net  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2009-02-25 17:27 | 我裝的明明就是2005卻出現(xiàn)那個(gè)問(wèn)題
          我明明就裝的視2005,沒(méi)有2000啊!
          為什么用Java純連接的時(shí)候還出現(xiàn)Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket這個(gè)問(wèn)題啊?  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2009-03-02 12:38 | 為何
          我的是xp,也是這個(gè)問(wèn)題。微軟太惡心了。  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2009-03-18 19:05 | agui2007
          打上sp4的補(bǔ)丁就好了
          還有打補(bǔ)丁時(shí)要注意,exe文件是解壓縮還要自己雙擊setup的  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2009-04-11 00:47 | 真bt的問(wèn)題呀
          我SP3 SP4 ,SQLServer 2000 JDBC驅(qū)動(dòng)裝了 環(huán)境變量設(shè)了
          三個(gè)包也導(dǎo)入了 在eclipse里面和MyEclipse里面都不能連接成功!
          這段時(shí)間把頭都搞大了 煩呀!
          有哪個(gè)高手能幫我解決的 聯(lián)系我呀!十分感謝
          qq:466651088
          email:ken2008huang@126.com
          感謝大家了!  回復(fù)  更多評(píng)論
            
          # 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  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄](méi)
          2009-04-21 20:09 | sam
          是啊,請(qǐng)高手幫忙一下,小弟也遇到這樣的問(wèn)題,sp4補(bǔ)丁裝上了,但是就是連接不了  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄](méi)
          2009-04-26 19:26 | 菜鳥(niǎo)
          我用的SQL2005和MyEclipse連接,在學(xué)校連的上到自己的機(jī)器上也出現(xiàn)和上面一樣的問(wèn)題,急死人了哎,哪個(gè)高手幫忙下QQ:691259685。感激不盡!!!  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄](méi)
          2009-04-27 22:28 | 菜鳥(niǎo)
          課能是出現(xiàn)這樣的問(wèn)題!!我也不是很清楚,我是這樣解決的.
          -----連接出現(xiàn)的問(wèn)題
          private static final String DRIVER="com.microsoft.jdbc.sqlserver.SQLServerDriver"; private static final String URL="jdbc:microsoft:sqlsever://localhost:1433;databasename=數(shù)據(jù)庫(kù)的名稱";
          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不能為空,應(yīng)為MYCLIPSE和SQL的連接只能和sql身份驗(yàn)證的用戶名和密碼才能正確的連接。和WINDOWS的身份驗(yàn)證連接不行。呵呵這是我的理解,我也解決了這個(gè)問(wèn)題,希望大家?guī)臀铱纯矗Mo出建議。  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2009-04-28 21:25 | carol.haul
          @sssss
          你的方法我試了,很管用,謝謝,一直困擾我多日的問(wèn)題終于解決了,真的謝謝你~  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2009-07-24 14:43 |
          這些方法我都試了,還是不行  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄](méi)
          2009-07-26 23:47 | l
          sql的兩種方式windows和sql是否都能連接上sqlserver  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2009-08-23 08:48 | xiu
          是不是端口的問(wèn)題啊,我跟大家一樣的情況。剛發(fā)現(xiàn)TCP端口寫(xiě)錯(cuò)了,在服務(wù)器端和客戶端網(wǎng)絡(luò)實(shí)用工具中設(shè)置一樣的端口,在程序中連接數(shù)據(jù)庫(kù)的時(shí)候也對(duì)應(yīng)一樣就可以了,我的是這樣解決的  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2010-04-20 22:42 | 網(wǎng)管軟件
          在命令窗口執(zhí)行Netstat -a -b 查看有沒(méi)有sqlsvr.exe占用端口,如果沒(méi)有在用SQLServer企業(yè)管理器中數(shù)據(jù)庫(kù)的屬性設(shè)置網(wǎng)絡(luò)參數(shù),把TCP/IP協(xié)議啟用 端口為1433 上面的問(wèn)題大都是這個(gè)原因.  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄](méi)
          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運(yùn)行的,我什么辦法都試過(guò)了,希望那位高手幫我解決一下  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2011-01-11 18:03 | 錢宇皓
          我的是XP系統(tǒng)裝SQL2005也是出現(xiàn)上述問(wèn)題!!跪求高手幫助!!郵箱qq429626538@163.com  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2011-03-12 16:46 | ltsznh
          其實(shí)問(wèn)題也許很簡(jiǎn)單,檢查下防火墻是不是開(kāi)著呢,關(guān)閉->搞定  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2012-03-29 14:04 | 大道
          @jinglecat
            回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
          2012-03-29 14:13 | o2o
          汗,慢慢研究  回復(fù)  更多評(píng)論
            
          # re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登錄](méi)
          2012-09-04 21:28 | 123
          同出現(xiàn)這個(gè)問(wèn)題,上面的都試過(guò)不行,求解決方案!!!297020949@qq.com  回復(fù)  更多評(píng)論
            
          主站蜘蛛池模板: 永安市| 台北市| 盘锦市| 克什克腾旗| 临西县| 汨罗市| 兴宁市| 高台县| 雅江县| 靖远县| 英吉沙县| 昌邑市| 昆山市| 澳门| 策勒县| 都昌县| 鄂伦春自治旗| 鄢陵县| 武强县| 井研县| 滨海县| 高陵县| 灵丘县| 通城县| 文化| 渑池县| 蕉岭县| 电白县| 共和县| 河东区| 固始县| 桂林市| 岫岩| 沁源县| 民县| 沙洋县| 宁津县| 治县。| 无为县| 廊坊市| 三都|