conexión con base de datos

[Zorba]

Hola tengo nua aplicacion de escritorio hecha con netbeans 6.1. Mi
entorno de desarrollo es una virtual pc con windows 2000 y sqlserver
2000. Como el server de base de datos del entorno de producción es
sqlServer 7, usé como driver JTDS. en desarrollo todo anda bien pero
en producción no conecta y devuelve el siguiente error:


C:\carga0506\dist_0506>java -jar Faba.jar
[TopLink Info]: 2008.06.13 02:23:54.898--ServerSession(24093812)--
TopLink, versi
on: Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))
13-jun-2008 14:23:55 org.jdesktop.application.Application$1 run
GRAVE: Application class faba.sab.carga.main.CargaDatosApp failed to
launch
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build
b09d-fcs (12/
06/2007))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Network error IOException:
Connection
refused: connect
Error Code: 0
at
oracle.toplink.essentials.exceptions.DatabaseException.sqlException(D
atabaseException.java:305)
at
oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultCo
nnector.java:102)
at
oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasourc
e(DatasourceLogin.java:184)
at
oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.login
AndDetectDatasource(DatabaseSessionImpl.java:582)
at
oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login
(EntityManagerFactoryProvider.java:280)
at
oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.de
ploy(EntityManagerSetupImpl.java:229)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactory
Impl.getServerSession(EntityManagerFactoryImpl.java:93)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactory
Impl.createEntityManagerImpl(EntityManagerFactoryImpl.java:126)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactory
Impl.createEntityManagerImpl(EntityManagerFactoryImpl.java:120)
at
oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.
createEntityManager(EntityManagerFactoryImpl.java:91)
at
faba.sab.carga.view.CargaDatosView.initComponents(CargaDatosView.java
:1439)
at
faba.sab.carga.view.CargaDatosView.<init>(CargaDatosView.java:86)
at
faba.sab.carga.main.CargaDatosApp.startup(CargaDatosApp.java:28)
at org.jdesktop.application.Application$1.run(Application.java:
171)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.sql.SQLException: Network error IOException:
Connection refused:
connect
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java
:385)
at
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java
:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultCo
nnector.java:100)
... 20 more
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(SharedSoc
ket.java:304)
at
net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255)
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java
:310)
... 25 more
Exception in thread "AWT-EventQueue-0" java.lang.Error: Application
class faba.s
ab.carga.main.CargaDatosApp failed to launch
at org.jdesktop.application.Application$1.run(Application.java:
177)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1
(Build b0
9d-fcs (12/06/2007))):
oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Network error IOException:
Connection
refused: connect
Error Code: 0
at
oracle.toplink.essentials.exceptions.DatabaseException.sqlException(D
atabaseException.java:305)
at
oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultCo
nnector.java:102)
at
oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasourc
e(DatasourceLogin.java:184)
at
oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.login
AndDetectDatasource(DatabaseSessionImpl.java:582)
at
oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login
(EntityManagerFactoryProvider.java:280)
at
oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.de
ploy(EntityManagerSetupImpl.java:229)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactory
Impl.getServerSession(EntityManagerFactoryImpl.java:93)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactory
Impl.createEntityManagerImpl(EntityManagerFactoryImpl.java:126)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactory
Impl.createEntityManagerImpl(EntityManagerFactoryImpl.java:120)
at
oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.
createEntityManager(EntityManagerFactoryImpl.java:91)
at
faba.sab.carga.view.CargaDatosView.initComponents(CargaDatosView.java
:1439)
at
faba.sab.carga.view.CargaDatosView.<init>(CargaDatosView.java:86)
at
faba.sab.carga.main.CargaDatosApp.startup(CargaDatosApp.java:28)
at org.jdesktop.application.Application$1.run(Application.java:
171)
... 8 more
Caused by: java.sql.SQLException: Network error IOException:
Connection refused:
connect
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java
:385)
at
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java
:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultCo
nnector.java:100)
... 20 more
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(SharedSoc
ket.java:304)
at
net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255)
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java
:310)
... 25 more

Agradecería mucho que alguien me diera una mano porque no le encuentro
la vuelta.
Muchas gracias

[Alfredo (Pela)]

Estimado, sabes que en el trabajo tuvimos problemas con el driver  "JTDS", y cambiamos por el driver de Microsoft url: "http://www.microsoft.com/downloads/details.aspx?familyid=c47053eb-3b64-4794-950d-81e1ec91c1ba&displaylang=en", que hasta ahora no tuvimos problema.


Saludos,
Alfredo.

[Zorba]

Muchas gracias Alfredo por responderme. El problema es que me tengo
que conectar a un server SQL 7, por eso estoy usando este driver,
según veo el que vos me decís solo se puede usar con 2000 o 2005

Saludos, Zorba

On 16 jun, 15:47, "Alfredo (Pela)" <pela2rjalfr...@gmail.com> wrote:
> Estimado, sabes que en el trabajo tuvimos problemas con el driver "JTDS", y

> cambiamos por el driver de Microsoft url: "http://www.microsoft.com/downloads/details.aspx?familyid=c47053eb-3b6...",

> que hasta ahora no tuvimos problema.
>
> Saludos,
> Alfredo.
>

[waz waz]

Ya revisaste los accesos de red, en tu ambiente de produccion hiciste telnet, creeria que es mas de accesos que del driver, no se si estare equibocado.

saludos

2008/6/13, Zorba <rinco...@gmail.com>:

[waz waz]

por cierto los drivers que te recomienda Alfredo es necesario el SP4 para la base.

2008/6/24, waz waz <william...@gmail.com>: