|
Home > Archive > SQL Server JDBC > April 2005 > [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
|
|
|
| I'm using JBuilder X, writing a client application and connecting to
database
SQL Server 2000 with JDBC driver.
when i have Windows Xp Pro with service Pack 1
i don't have a problem
all works
now with Windows Xp Pro and service Pack 2 i have this problem
[Microsoft][SQLServe
r 2000 Driver for JDBC]Error establishing socket.
See com.borland.dx.dataset.DataSetException error code: BASE+66
com.borland.dx.dataset.DataSetException: [Microsoft][SQLServe
r 2000 Driver
for JDBC]Error establishing socket.
at com.borland.dx.dataset.DataSetException.a(Unknown Source)
at com.borland.dx.dataset.DataSetException. throwException(Unkno
wn Source)
at com.borland.dx.dataset.DataSetException. SQLException(Unknown
Source)
at com.borland.dx.sql.dataset.Database. openConnection(Unkno
wn Source)
at com.borland.dx.sql.dataset.Database. createPreparedStatem
ent(Unknown
Source)
at com.borland.dx.sql.dataset.o.a(Unknown Source)
at com.borland.dx.sql.dataset.o.d(Unknown Source)
at com.borland.dx.sql.dataset.o.f(Unknown Source)
at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)
at com.borland.dx.sql.dataset.QueryDataSet.refresh(Unknown Source)
at com.borland.dx.sql.dataset.QueryDataSet. executeQuery(Unknown
Source)
at prog.Login. buttonControl1_actio
nPerformed(Login.java:131)
at prog.Login. buttonControl1_keyRe
leased(Login.java:207)
at prog.Login$2.keyReleased(Login.java:79)
at java.awt.AWTEventMulticaster. keyReleased(AWTEvent
Multicaster.java:201)
at java.awt.Component. processKeyEvent(Comp
onent.java:3680)
at javax.swing.JComponent. processKeyEvent(JCom
ponent.java:2014)
at java.awt.Component. processEvent(Compone
nt.java:3553)
at java.awt.Container. processEvent(Contain
er.java:1164)
at java.awt.Component. dispatchEventImpl(Co
mponent.java:2593)
at java.awt.Container. dispatchEventImpl(Co
ntainer.java:1213)
at java.awt.Component. dispatchEvent(Compon
ent.java:2497)
at java.awt. LightweightDispatche
r. processKeyEvent(Cont
ainer.java:2155)
at java.awt. LightweightDispatche
r. dispatchEvent(Contai
ner.java:2135)
at java.awt.Container. dispatchEventImpl(Co
ntainer.java:1200)
at java.awt.Window. dispatchEventImpl(Wi
ndow.java:914)
at java.awt.Component. dispatchEvent(Compon
ent.java:2497)
at java.awt.EventQueue. dispatchEvent(EventQ
ueue.java:339)
at
java.awt.EventDispatchThread. pumpOneEventForHiera
rchy
(EventDispatchThread
.java:131)
at
java.awt.EventDispatchThread. pumpEventsForHierarc
hy
(EventDispatchThread
.java:98)
at java.awt.EventDispatchThread. pumpEvents(EventDisp
atchThread.java:93)
at java.awt.EventDispatchThread. run(EventDispatchThr
ead.java:85)
Chained exception:
java.sql.SQLException: [Microsoft][SQLServe
r 2000 Driver for JDBC]Error
establishing socket.
at com.microsoft.jdbc.base.BaseExceptions. createException(Unkn
own 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. SQLServerImplConnect
ion.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(Driver
Manager.java:517)
at java.sql.DriverManager. getConnection(Driver
Manager.java:177)
at com.borland.dx.sql.dataset.Database. openConnection(Unkno
wn Source)
at com.borland.dx.sql.dataset.Database. createPreparedStatem
ent(Unknown
Source)
at com.borland.dx.sql.dataset.o.a(Unknown Source)
at com.borland.dx.sql.dataset.o.d(Unknown Source)
at com.borland.dx.sql.dataset.o.f(Unknown Source)
at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)
at com.borland.dx.sql.dataset.QueryDataSet.refresh(Unknown Source)
at com.borland.dx.sql.dataset.QueryDataSet. executeQuery(Unknown
Source)
at prog.Login. buttonControl1_actio
nPerformed(Login.java:131)
at prog.Login. buttonControl1_keyRe
leased(Login.java:207)
at prog.Login$2.keyReleased(Login.java:79)
at java.awt.AWTEventMulticaster. keyReleased(AWTEvent
Multicaster.java:201)
at java.awt.Component. processKeyEvent(Comp
onent.java:3680)
at javax.swing.JComponent. processKeyEvent(JCom
ponent.java:2014)
at java.awt.Component. processEvent(Compone
nt.java:3553)
at java.awt.Container. processEvent(Contain
er.java:1164)
at java.awt.Component. dispatchEventImpl(Co
mponent.java:2593)
at java.awt.Container. dispatchEventImpl(Co
ntainer.java:1213)
at java.awt.Component. dispatchEvent(Compon
ent.java:2497)
at java.awt. LightweightDispatche
r. processKeyEvent(Cont
ainer.java:2155)
at java.awt. LightweightDispatche
r. dispatchEvent(Contai
ner.java:2135)
at java.awt.Container. dispatchEventImpl(Co
ntainer.java:1200)
at java.awt.Window. dispatchEventImpl(Wi
ndow.java:914)
at java.awt.Component. dispatchEvent(Compon
ent.java:2497)
at java.awt.EventQueue. dispatchEvent(EventQ
ueue.java:339)
at
java.awt.EventDispatchThread. pumpOneEventForHiera
rchy
(EventDispatchThread
.java:131)
at
java.awt.EventDispatchThread. pumpEventsForHierarc
hy
(EventDispatchThread
.java:98)
at java.awt.EventDispatchThread. pumpEvents(EventDisp
atchThread.java:93)
at java.awt.EventDispatchThread. run(EventDispatchThr
ead.java:85)
ava.sql.SQLException: [Microsoft][SQLServe
r 2000 Driver for JDBC]Error
establishing socket.
at com.microsoft.jdbc.base.BaseExceptions. createException(Unkn
own 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. SQLServerImplConnect
ion.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(Driver
Manager.java:517)
at java.sql.DriverManager. getConnection(Driver
Manager.java:177)
at com.borland.dx.sql.dataset.Database. openConnection(Unkno
wn Source)
at com.borland.dx.sql.dataset.Database. createPreparedStatem
ent(Unknown
Source)
at com.borland.dx.sql.dataset.o.a(Unknown Source)
at com.borland.dx.sql.dataset.o.d(Unknown Source)
at com.borland.dx.sql.dataset.o.f(Unknown Source)
at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)
at com.borland.dx.sql.dataset.QueryDataSet.refresh(Unknown Source)
at com.borland.dx.sql.dataset.QueryDataSet. executeQuery(Unknown
Source)
at prog.Login. buttonControl1_actio
nPerformed(Login.java:131)
at prog.Login. buttonControl1_keyRe
leased(Login.java:207)
at prog.Login$2.keyReleased(Login.java:79)
at java.awt.AWTEventMulticaster. keyReleased(AWTEvent
Multicaster.java:201)
at java.awt.Component. processKeyEvent(Comp
onent.java:3680)
at javax.swing.JComponent. processKeyEvent(JCom
ponent.java:2014)
at java.awt.Component. processEvent(Compone
nt.java:3553)
at java.awt.Container. processEvent(Contain
er.java:1164)
at java.awt.Component. dispatchEventImpl(Co
mponent.java:2593)
at java.awt.Container. dispatchEventImpl(Co
ntainer.java:1213)
at java.awt.Component. dispatchEvent(Compon
ent.java:2497)
at java.awt. LightweightDispatche
r. processKeyEvent(Cont
ainer.java:2155)
at java.awt. LightweightDispatche
r. dispatchEvent(Contai
ner.java:2135)
at java.awt.Container. dispatchEventImpl(Co
ntainer.java:1200)
at java.awt.Window. dispatchEventImpl(Wi
ndow.java:914)
at java.awt.Component. dispatchEvent(Compon
ent.java:2497)
at java.awt.EventQueue. dispatchEvent(EventQ
ueue.java:339)
at
java.awt.EventDispatchThread. pumpOneEventForHiera
rchy
(EventDispatchThread
.java:131)
at
java.awt.EventDispatchThread. pumpEventsForHierarc
hy
(EventDispatchThread
.java:98)
at java.awt.EventDispatchThread. pumpEvents(EventDisp
atchThread.java:93)
at java.awt.EventDispatchThread. run(EventDispatchThr
ead.java:85)
Thanks very much!
| |
| Alin Sinpalean 2005-04-01, 8:01 pm |
| Take a look at the firewall configuration. XP SP2 comes with a firewall
that blocks all ports by default.
Alin,
The jTDS Project.
| |
|
| thanks .
the firewall want's one exeption for sql server
|
|
|
|
|