[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

xinnian25 2011-12-17 02:56:35

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

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

	at org.gl.DBToolsX.getConnection(DBToolsX.java:16)

	at org.gl.Login.service(Login.java:32)

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

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

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

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

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

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

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

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

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

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

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

2011-12-17 14:55:16 org.apache.catalina.core.StandardWrapperValve invoke

严重: Servlet.service() for servlet login threw exception

java.lang.NullPointerException

	at org.gl.Login.service(Login.java:36)

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

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

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

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

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

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

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

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

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

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

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

已经安装了SP4补丁了，查询分析器版本8.00.2039

操作系统 XP 2002版本 SP3

...全文

67 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

xinnian25 2011-12-18

打赏
举报

本地的数据库啊，就那个IP

唐诗三百首 2011-12-18

打赏
举报

[Quote=引用 5 楼 xinnian25 的回复:]
C:\Documents and Settings\gl>telnet 127.0.0.1 1433
正在连接到127.0.0.1...不能打开到主机的连接，在端口 1433: 连接失败
[/Quote]
1.确认sql service启动了没.
2.服务器防火墙暂关闭试试.
3.不要用127.0.0.1,用实体IP.

xinnian25 2011-12-18

打赏
举报

没人能解决？

xinnian25 2011-12-17

打赏
举报

C:\Documents and Settings\gl>telnet 127.0.0.1 1433
正在连接到127.0.0.1...不能打开到主机的连接，在端口 1433: 连接失败

xinnian25 2011-12-17

打赏
举报

[Quote=引用 2 楼 hllfl 的回复:]
查下端口
http://wenku.baidu.com/view/b63bd2270722192e4536f628.html
[/Quote]

端口是1433

我的是sql server 2000

hllfl 2011-12-17

打赏
举报

SQL2000:

String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // 加载JDBC驱动

String dbURL = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=lianxi"; // 连接服务器和数据库

SQL2005 && 2008:

String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; // 加载JDBC驱动

String dbURL = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=lianxi"; // 连接服务器和数据库

hllfl 2011-12-17

打赏
举报

查下端口
http://wenku.baidu.com/view/b63bd2270722192e4536f628.html

xinnian25 2011-12-17

打赏
举报

url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=yumen";

    user = "sa";  

    pwd = "";

"java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver" 解决方案 [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. 解决了jsp连接　sql server 2000的问题

准备环境 Windows XP+JDK5.0+Microsoft SQL Server 2000个人版+JCreator(或Eclipse) 下载数据库驱动程序SQL Server 2000 Driver for JDBC Service Pack 3.exe 安装完毕后在C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib 目录下有三个包msbase.jar mssqlserver.jar msutil.jar 1、在命令行下编译运行，配置环境变量将这三个包的路径加入CLASSPATH中 2、在JCreator中配置选项 JDK配置文件编辑添加存档路径添加三个包 3、在Eclipse此中选择项目的构建路径——库—— 添加外部JAR 将这三个添加进去二、出现的问题及解决办法 1、是不是出现了Error establishing socket之类的错误

你编写java程序出现了如下的错误提示【[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket】

今天做一个特殊的业务处理，用JDBC连接SQLServer数据库加载驱动的时候，报如下错误： java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. at com.microsoft.jdbc.base.BaseExceptions.createException(

疑难问题

22,209

社区成员

121,731

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章