Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

843859Nov 7 2006 — edited Nov 8 2006
here's my code that tries to connect with MSSql server.

import java.*;
import java.sql.*;
import javax.sql.*;

public class ConnectMsSql {

public ConnectMsSql() {
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://FLAME:1433;");
}catch(Exception exception){
exception.printStackTrace();
System.out.println(exception.getMessage());
System.out.println("Database Connection Failed");

}
}

}

public class database(){

public static void main(String[] args){
ConnectMsSql x = new ConnectMsSql();

}


}


and i'm receiving a runtime error message like this one..


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

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

at prototypesteno.ConnectMsSql.<init>(ConnectMsSql.java:24)

at prototypesteno.database.main(database.java:28)

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

Database Connection Failed

thanks!! I need to fix this asap.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2006
Added on Nov 7 2006
2 comments
316 views