Home > Archive > SQL Server JDBC > December 2005 > 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 Error establishing socket
jlopes151

2005-11-16, 11:23 am

Trying to set up jdbc/MS SQLServer on XP. I get this message when I test the
conection in java. I'm actually moving code to a new box. I've used the test
code under w2k with no problems.

Thanks for your help
Kamil Sykora [MSFT]

2005-12-06, 11:23 am

Hello,

For some common causes of this error and troubleshooting please see:
http://support.microsoft.com/defaul...kb;en-us;313178

On a Windows XP installation, also check if your Windows Firewall allows
inbound TCP/IP connections to your SQL Server instance. The JDBC driver can
only use TCP/IP to connect unlike other MDAC clients which can connect
using shared memory, named pipes, TCP/IP etc.

A quick way to test connectivity over TCP/IP would be to connect to your
SQL Server from Query Analyzer by using "tcp:servername" in the SQL Server
text box.

Thanks,
Kamil

Kamil Sykora [MSFT]
Microsoft Developer Support - Webdata

This posting is provided "AS IS", with no warranties, and confers no
rights.

Please do not send email directly to this alias. This alias is for
newsgroup
purposes only.
--------------------
| Thread-Topic: Error establishing socket
| From: =?Utf-8?B?amxvcGVzMTUx?= < jlopes151@discussion
s.microsoft.com>
| Subject: Error establishing socket
| Date: Wed, 16 Nov 2005 08:30:14 -0800
|
| Trying to set up jdbc/MS SQLServer on XP. I get this message when I test
the
| conection in java. I'm actually moving code to a new box. I've used the
test
| code under w2k with no problems.
|
| Thanks for your help
|

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com