Tentando conectar no SQL Server 2000 no windows 7

27 de abril de 2010 2 respostas

sandrobit 27 de abril de 2010

Ola pessoal, já estou algum tempo tentando conectar ao sql server 2000 usando o driver da jtds no windows 7 e estou recebendo a msg abaixo a qual já venho pesquisando e não encontrei ainda umasolução e não sei o q estou errando ou onde esta o erro.

Codigo da conexao:

DB db = new DB();
       db.dbConnect("jdbc:jtds:sqlserver://BIT:1433/DBTESTE","","");

Erro:

java.sql.SQLException: Network error IOException: Connection refused: connect
	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:410)
	at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
	at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at DB.dbConnect(testConnection.java:23)
	at testConnection.main(testConnection.java:8)
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.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:307)
	at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:257)
	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:311)

Se alguem poder ajudar ficaria agradecido!!

Bit

2 Respostas

mathiasnw 28 de abr. de 2010

Voce verificou a instancia do sql server?

DB db = new DB();  
   db.dbConnect("jdbc:jtds:sqlserver://BIT:1433/DBTESTE;instance=SQLEXPRESS","","");

sandrobit 29 de abr. de 2010

mathiasnw:
Voce verificou a instancia do sql server?

DB db = new DB(); db.dbConnect("jdbc:jtds:sqlserver://BIT:1433/DBTESTE;instance=SQLEXPRESS","","");

kra obrigado por responder.
modifiquei agora esta apresentando o erro abaixo:

java.sql.SQLException: Unable to get information from SQL Server: bit.
	at net.sourceforge.jtds.jdbc.MSSqlServerInfo.&lt;init&gt;(MSSqlServerInfo.java:97)
	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.&lt;init&gt;(ConnectionJDBC2.java:276)
	at net.sourceforge.jtds.jdbc.ConnectionJDBC3.&lt;init&gt;(ConnectionJDBC3.java:50)
	at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at DB.dbConnect(testConnection.java:23)
	at testConnection.main(testConnection.java:8)

Criado 27 de abril de 2010

Ultima resposta 29 de abr. de 2010

Respostas 2

Participantes 2

2 Respostas

Topicos relacionados