Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: Error while running Query

    Hi,

    SQL Server 7
    When i ran a query in query analyzer i am getting the below error.
    once i closed and opened the query analyzer and ran the same query it worked fine.

    pls the error which i got in first time.

    Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
    [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
    [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
    [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
    [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
    [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
    [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
    [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
    [Microsoft][ODBC SQL Server Driver]TDS buffer length too large
    [Microsoft][ODBC SQL Server Driver]TDS buffer length too large
    [Microsoft][ODBC SQL Server Driver]TDS buffer length too large
    [Microsoft][ODBC SQL Server Driver]TDS buffer length too large
    [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
    [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
    [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
    [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
    [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
    [Microsoft][ODBC SQL Server Driver]TDS buffer length too large
    [Microsoft][ODBC SQL Server Driver]TDS buffer length too large
    [Microsoft][ODBC SQL Server Driver]TDS buffer length too large

    Pls help me in this

    TIA
    Adil

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    So, after you reopened QA the same query ran with no errors? Are you suspecting you're going to get it again?

  3. #3
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115
    hi
    thanks for the reply

    yes, i'm worried if it comes again whats the solution for it.
    pls help me out.


    TIA

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The problem seems to be that you've got some bits stuck in your network cable. Remove the cable, shake it vigorously in all four cardinal compass points (north, east, south, and west), and plug it back in. Things should work just fine then!

    On a slightly more serious note, removing the network cable will actually fix the problem in most cases. There was some kind of communication error, possibly lost data/framing error/digi-voodoo/etc. When you remove the network cable for any significant amount of time (over a few seconds), the NIC resets. When the cable is reattached, the NIC reconnects, and whatever problem there was is magically gone.

    If nothing else, the attention that you get when everybody thinks that you've clearly lost what little mind you might have once had, then your bizzare behavior appears to fix the problem will get you lots of digi-voodoo status.

    -PatP

  5. #5
    Join Date
    Sep 2003
    Posts
    522
    that's an interesting solution, but considering the real reason for the above error actually very precise. now, here's your reference material in this regard.

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Pat Phelan, you need to be more carefull about your advice. I followed your intructions and got bits all over my carpet. They are extremely hard to get out, and since the dang things carry a static charge they stick to my cat and he has tracked them all over the house. On a positive note, they seemed to pass through his digestive tract pretty quickly.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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