يحدث هذا الاستثناء عندما اريد الاتصال بقاعدة بيانات SQL Server 2000
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:193) at test.MyConnect.<init>(MyConnect.java:18) at test.MyConnect.main(MyConnect.java:28)
الكود
package test;
import java.sql.*;
import com.microsoft.sqlserver.jdbc.SQLServerDriver;
public class MyConnect{
private Connection conn;
public MyConnect()throws SQLException {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
conn = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1;DatabaseName=AddressBook;user=uthman,password=123");
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args)throws SQLException {
monitor.MonitorManager.setMonitorAsDefaultIO();
try {
MyConnect mc=new MyConnect();
} catch (SQLException e) {
e.printStackTrace();
}
}
}.jpg)