Upgrade 7 to 2000 and ODBC "Unknown Token" Error

  • We were SQL 7.0SP2, Mdac 2.5RTM, ODBC version 3.70.09.61.

    Upgraded to SQL2KSP2, MDAC2.6SP2, ODBC version 2000.80.746.00 + SecurityFix

    As stated in Microsoft instructions...we did a sp_updatestats in QA and it worked on a smaller database(2Gig) and only did 20% of the big 90Gig DB before we got the following error:

    .....

    .....

    Updating PROD.F01151Z1

    Updating PROD.F4343

    Updating PROD.F4572Z1

    [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server

    We are on Win2K Advance Server SP2. No errors reported in Windows or SQL.

    Any ideas??

    Thanks,

    Faisal

  • quote:


    [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server

    We are on Win2K Advance Server SP2. No errors reported in Windows or SQL.

    Any ideas??


    We occasionally get Unknown Token errors.

    These generally appear to be down to either deadlock problems or network problems corrupting the data stream.

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply