Windows XP Service Pack 2 and JDBC socket failure

From: Dana J. Hall (anonymous_at_discussions.microsoft.com)
Date: 09/01/04 

Date: Wed, 1 Sep 2004 10:38:17 -0700

Hello,
This is my first post so I apologize for any errors in my
post.
The problem: my java programs that use Microsoft JDBC
drivers will no longer connect to the SQL Server 2000
database after I have installed XP SP2. I am running the
latest 2000 JDBC drivers from Microsoft. The error I am
getting is:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver
for JDBC]Error establishing socket.

My other java programs that connect to SQL Server 2000
use ODBC and work fine, only the programs that use JDBC
have a problem.

I have done the obvious tasks of setting the firewall
settings to allow sql server, the port 1433 etc. and
nothing works.
Any insight would be appreciated.
Thanks,
Dana Hall

Relevant Pages

  • Re: [ubuntu] ODBC
    ... Managed to get OOo working with the standard M$ JDBC ... >> Anyone had any luck using the M$ SQL Server JDBC drivers on a Ubuntu ...
    (Ubuntu)
  • Re: JDBC URLs ...not really URLs?
    ... And neither jdbc nor mysql are valid schemes... ... defines the format for it, and it's unlikely that you'll find conflicting uses in the wild. ... URIs, because there is no canonical format for the driver-part. ... MySQL uses //host:port/database?params, similar to HTTP, but other drivers use other formats. ...
    (comp.lang.java.programmer)
  • Re: MS Access databases
    ... Just to clarify things, you *are* using JDBC in your example, but you're ... SQL-Server instead of MS Access, and in the case of SQL-server i pointed to ... AFAIK there exists no JDBC-driver of type 4 for MS Access. ... The list says that BCS has drivers of type 4, ...
    (comp.lang.java.databases)
  • Re: Jdbc connect to a Plain text file
    ... Michael Borgwardt wrote: ... with csv/tsv files using JDBC drivers. ... find them pointing to commercial products, some with prices in the US$ ...
    (comp.lang.java.programmer)
  • Re: SQLServer 2000 Driver for JDBC behaviour on SQL Server restart
    ... that the socket it had been using for it's connection to the DBMS ... is dead during a user call to a JDBC method. ... Drivers typically do *not* transparently reconnect when a DBMS goes ... Some drivers and DBMSes do have failover ...
    (comp.lang.java.databases)
Loading