Windows XP Service Pack 2 and JDBC socket failure

anonymous_at_discussions.microsoft.com
Date: 09/01/04

  • Next message: Anna: "SQL Server SP3a via JDBC SP2"
    Date: Wed, 1 Sep 2004 15:15:45 -0700
    
    

    Hello all,
    I found my own solution: upgrade the SQL Server to
    Service Pack 3a (SP3a). This took care of the problem.

    Thanks,
    Dana Hall

    >-----Original Message-----
    >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
    >.
    >


  • Next message: Anna: "SQL Server SP3a via JDBC SP2"

    Relevant Pages

    • Re: sendStringParameterAsUnicode: How to insert unicode data corre
      ... After checking with Microsoft it turns out that transmitting Unicode ... requires a change in the data format sent to the JDBC Receiver channel. ... We have contacted SAP and Microsoft. ... We are using SAP XI and connecting it to SQL Server 2005 using JDBC. ...
      (microsoft.public.sqlserver.jdbcdriver)
    • RE: BUG: JDBC connection disconnected, cant reconnect
      ... we've replaced the MS JDBC driver with jTDS JDBC driver, ... There is really nothing the driver can do that will take down SQL Server. ... Our problem is that the JDBC connection running on the localhost ... and then we can't reconnect to the database ...
      (microsoft.public.sqlserver.jdbcdriver)
    • RE: SQL Server SP3a via JDBC SP2
      ... | Subject: RE: SQL Server SP3a via JDBC SP2 ... | Content-Type: text/plain; ... | Carb Simien, thanks for your reply, but the query ...
      (microsoft.public.sqlserver.jdbcdriver)
    • RE: Installing SS 2005 JDBC Driver 1.1
      ... SQL Server 2005 JDBC Driver\sqljdbc_1.1) ... I see the .jar file but I have no idea how/where I am to define the ... Panel that a SQL Server JDBC is installed. ... How do I install this? ...
      (microsoft.public.sqlserver.jdbcdriver)
    • RE: JDBC - Cant get unicode with ResultSet.getString()
      ... The data is correct in Sql Server - I viewed it there. ... And it is the jdbc getString() that returns it wrong, ... So for somereason the Microsoft Sql Server JDBC driver is not returning ...
      (microsoft.public.sqlserver.odbc)

    Loading