RE: Takes too long time to connect to DB server

From: Carb Simien [MSFT] (CarbinoS_at_online.microsoft.com)
Date: 08/03/04 

Date: Tue, 03 Aug 2004 17:12:10 GMT

--------------------
| Thread-Topic: Takes too long time to connect to DB server
| thread-index: AcRz+8jvJ5ekdTCKQJG5hK9goJ9mZQ==
| X-WBNR-Posting-Host: 193.113.37.7
| From: =?Utf-8?B?ZWhhYmlu?= <ehabin@discussions.microsoft.com>
| Subject: Takes too long time to connect to DB server
| Date: Tue, 27 Jul 2004 10:04:31 -0700
| Lines: 10
| Message-ID: <8E4EFADD-1990-4DDE-B073-E4182C28B990@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.jdbcdriver:6207
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| Hi,
| I'm using com.microsoft.jdbc.sqlserver.SQLServerDriver to connect to MS
SQL 2000.
| This take really long time even if I try to connect to the server from
the same machine.. about 20 seconds... just to get one record from a table.
| However, if I use sun.odbc.jdbc.OdbcJdbcDriver for the same connection,
it returns result instantly..
| I was using MS JDBC Service Pack 2.
| Does anybody have the same experience please ?
| Thanks in advance.
|
| Habin.
|
|

Hello,

Can you please post your JDBC code and table schema used to demonstrate
this problem? How many rows does your table have?

Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Relevant Pages

  • RE: Search Result on asp = nothing
    ... On the tracking tab you need to select your web site for the WWW server. ... Microsoft Application Center & Index Server Support ... | Content-Type: text/plain; ...
    (microsoft.public.inetserver.indexserver)
  • RE: Root Permissions changed
    ... | Content-Type: text/plain; ... Produced By Microsoft MimeOLE V6.00.3790.0 ... "If you are using the version of Microsoft FrontPage 2002 Server Extensions ... Web sites on separate virtual servers. ...
    (microsoft.public.inetserver.iis)
  • RE: Save My Settings Wizard
    ... Could be a problem with the shortcut or it is missing.. ... | thread-index: AcQMVQNC3qTuxbB6SDm+sRPuyqUBzA== ... | Content-Type: text/plain; ... Produced By Microsoft MimeOLE V6.00.3790.0 ...
    (microsoft.public.office.misc)
  • RE: Help will not work...
    ... | thread-index: AcQbQbyKXm8l2sObSzqPwe1qDvZGTg== ... | X-Tomcat-NG: microsoft.public.office.misc ... | Content-Type: text/plain; ... Produced By Microsoft MimeOLE V6.00.3790.0 ...
    (microsoft.public.office.misc)
  • RE: numbering past 100
    ... | Thread-Topic: numbering past 100 ... | thread-index: AcQXfdPxGbgBLinfRkKeA1Lw+r3CLg== ... | Content-Type: text/plain; ... Produced By Microsoft MimeOLE V6.00.3790.0 ...
    (microsoft.public.word.pagelayout)
Loading