Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2003
    Location
    CA, East Bay
    Posts
    13

    Question Unanswered: HELP! ODBC becoming unusable

    Here goes: We have situation at a customer site where users are suddenly unable to connect to SQL 2K via ASP using ODBC via DSN. While the customer is in this state, our Windows clients, which connect using OLE DB (ADO) to the same DB as the ASP, seem to be connecting without problems. Therefore, the problem seems to be with ODBC.

    Additional details about the problem site:
    SQL ODBC 3.50
    Win2K Server SP 4.
    SQL2k SP2.
    MDAC 2.62
    <100 users total
    Moderate usage of our ASP interface

    Note: SQL2k and IIS are on the same LAN-side server.

    FYI: Another part of the problem is that I'm a developer and am not that familiar with the tools available to help me troubleshoot this kind of problem.

    We've tried using Perfmon to monitor connection pooling, but nothing stood-out.

    We've tried using netstat (with various switches), but nothing stood-out.

    Does anybody have any advice?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    At least apply SP3 to your SQL.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    http://www.winnetmag.com/Windows/Art...3507/3507.html and take help of ODBC trace.
    Check this KBA http://support.microsoft.com/default...b;EN-US;268591 and corresponding referenced KBAs to take help of ODBC tracing to troubleshoot the problem.

    Ensure both client and server are enabled with similar protocol, service packs as referred.
    Last edited by Satya; 03-30-04 at 03:52.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Apr 2003
    Location
    CA, East Bay
    Posts
    13
    Originally posted by rdjabarov
    At least apply SP3 to your SQL.
    Thanks. We will be advising them to update SQL to SP3, but it's not very comforting to us to give what they'll perceive as a solution, when we heavn't even identified the problem.

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    While many of us here know client connectivity, it's still a SQL Server forum, not SQL Client

    I'd follow Satya's suggestions, at least you can see for yourself if you're even getting to the server.

  6. #6
    Join Date
    Apr 2003
    Location
    CA, East Bay
    Posts
    13
    Originally posted by Satya
    http://www.winnetmag.com/Windows/Art...3507/3507.html and take help of ODBC trace.
    Check this KBA http://support.microsoft.com/default...b;EN-US;268591 and corresponding referenced KBAs to take help of ODBC tracing to troubleshoot the problem.

    Ensure both client and server are enabled with similar protocol, service packs as referred.
    That's some great information! But won't this only trace activity across an open connection (implicit or explicit)? If so, I'm not sure it'll help because the problems is that at some point, the ASP are simply unable to connect via DSN using ODBC.

    Given that it's as though SQL is simply inaccessable via the DSN, even when the ADO OLE DB client app is connecting fine, we've been speculating (with help from Microsoft) that the problem is with ODBC's connection pooling. We've tried to set-up performance logging of connection pooling in-house in an effort to determine it's potential usefulness to our scenario in production, but our in-house graphs show no activity...probably due to the relatively low activity in our development environment. We walked the customer through setting it up on their server anyhow.

    Just recently, the problem occurred again on the customer's server. Before they could reboot the server, we took the opportunity to run NETSTAT to view the sockets for clues, but there were less than 20 results. Possibly because they have SQL and IIS on the same server?

    This sucks because all we want to do is get an idea of how to duplicate the problem in a controlled environment so we can either a) adjust our ASP accordingly or b) give them a solution that we know addresses the problem.

    Thoughts, comments, advice?

  7. #7
    Join Date
    Apr 2003
    Location
    CA, East Bay
    Posts
    13

    Thumbs up

    Originally posted by rdjabarov
    While many of us here know client connectivity, it's still a SQL Server forum, not SQL Client

    I'd follow Satya's suggestions, at least you can see for yourself if you're even getting to the server.
    Was the frist comment a suggestion that my question (i.e. how to troubleshoot SQL connectivity issues) is outside of the scope of this forum? If so, please advise a more approriate forum. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •