JDBC x SQL Server 2000 x WinXP SP(Não conecta nem a pau)!

1 resposta
R

Ola galera estou com um problema desde que instalei o SP2 do Windows XP nao consigo fazer conectar com o SQl Server 2000 vejam o codigo e o erro:

import java.sql.*;

public class Teste {

	public static void main(String agr[]){
		
		try{
			Class.forName("net.sourceforge.jtds.jdbc.Driver");
			String url = "jdbc:jtds:sqlserver://localhost:1433";
			Connection con = DriverManager.getConnection(url,"sa","");
			if( con != null){
				System.out.println("Conectado como: sa");
			}
				
		}
		catch(SQLException ex){
			ex.printStackTrace();
			ex.getMessage();
			//System.out.println("Erro ao conectar com banco!!!");
		}
		catch(Exception ex){
			//ex.printStackTrace();
			System.out.println("Excecao qualquer!!!");
		}
		
	}
	
}

Erro:

java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:307)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:145)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Teste.main(Teste.java:10)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:225)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:257)
... 5 more

1 Resposta

R

Estou com o mesmo problema… faço minhas suas palavras (helpmeeeee)
(ja tentei o driver novo da microsoft mas a meleca nao funciona

Criado 29 de outubro de 2004
Ultima resposta 30 de out. de 2004
Respostas 1
Participantes 2