Re: Windows XP Service Pack 2 and JDBC socket failure

From: Yilei Wang (yileiw_at_online.microsoft.com)
Date: 09/21/04 

Date: Tue, 21 Sep 2004 15:30:16 GMT

JDBC connectivity goes through TCP/IP layer. You can further isolate this
problem by opening up Query Analyzer and typing "tcp:SQLInstanceName" for
sql server name. If it's not able to connect from another client to the
same SQL Server, that indicates problem exists on SQL Server end. JDBC has
nothing to do with this issue. You may want to redirect this question to
SQL group.

Relevant Pages

  • DB-Library (ntwdblib.dll) problem with NULL DBPROCESS - XP SP2/ SP3a?????
    ... DB-Library to access SQL Server. ... would break our JDBC connectivity to SQL Server with our Java Apps... ... it broke the connectivity of our Java ... Apps using JDBC. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL2005 sys tables
    ... Maybe you don't have the SQL Editor toolbar open. ... You can also change the database context by using the USE statement in the ... SQL Server Documentation Team ... I mean in sql2000 query analyzer I can do the select statement against ...
    (microsoft.public.sqlserver.security)
  • RE: select during transaction**
    ... > in query analyzer I want to update ... beacuse sql server decide on clustered index scan, therefore this statement must wait on releasing locks made by UPDATE ... because sql server chose clustered index seek and it didn't touch/need ... the data locking by UPDATE from first window. ...
    (microsoft.public.sqlserver.programming)
  • Summing tables in a UDF
    ... developed in Sybase into a SQL Server UDF. ... to run call the function in Query Analyzer even though it ... declare rentrev integer; ... What UDF type do I need to recreate this in SQL Server? ...
    (microsoft.public.sqlserver.programming)
  • Re: Using Query Analyzer with SQL 2005
    ... to 2005) was undone for the release of SP4. ... What version of SQL Server 2000 Query Analyzer are you using? ... or will I always need to keep a copy of SQL Server 2000 to install ...
    (microsoft.public.sqlserver.tools)
Loading