File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing." Watch "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing." New topic
Author

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing.

Ganesh Sharma Balijapalli
Greenhorn

Joined: Nov 11, 2011
Posts: 9
Hi,

i am trying to establish the jdbc connection using sql server 2000 and i am using winows 7 operating system and jdk 1.6. when i run the application it is giving the following 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 com.samplemvc.controller.UserFormController.doPost(UserFormController.java:24)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
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:128)
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:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Unknown Source)

Thnaks in Advence :-)
Hebert Coelho
Ranch Hand

Joined: Jul 14, 2010
Posts: 754

Hello Ganesh Sharma Balijapalli, welcome to JavaRanch.

Maybe your firewall is blocking the SqlServer port.


[uaiHebert.com] [Full WebApplication JSF EJB JPA JAAS with source code to download] One Table Per SubClass [Web/JSF]
Ganesh Sharma Balijapalli
Greenhorn

Joined: Nov 11, 2011
Posts: 9
Hello Hebert Coelho,

Thank you for your reply, i have disabled firewall and run the application but still it is giving the same exception.
do i have any alternate solution for this?


Thanks in Advance:-)


Hebert Coelho
Ranch Hand

Joined: Jul 14, 2010
Posts: 754

Maybe your url database has a connection is different configurations from your instaled SQLServer.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

Have you confirmed that SQL Server is actually listening at the port which you specified in your database connection? (By default SQL Server doesn't accept TCP/IP connections, a configuration change has to be made to allow it to do that.)
 
jQuery in Action, 2nd edition
 
subject: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing.
 
Similar Threads
Getting Error establishing socket. while running the application
getting error of sockets
Connection through Applet using SQLServer 2000 Driver for JDBC
Help appriciated. SQLServer 2000 JDBC exception.
SQL Exception -Error establishing socket