Microsoft KB Archive/827969

= PRB: &quot;Unhandled Token Type&quot; Error Message When You Run a Transact-SQL Statement That Contains a COMPUTE Clause =

Article ID: 827969

Article Last Modified on 10/29/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Driver for JDBC
 * Microsoft SQL Server 2000 Standard Edition

-



SYMPTOMS
When you run a Transact-SQL statement that contains a COMPUTE clause or a COMPUTE BY clause and you use a Microsoft SQL Server 2000 Driver for JDBC Service Pack 1 (SP1) driver to connect the Microsoft SQL Server 2000 server, the query may fail and you receive the following error message:

[Microsoft][SQL Server 2000 Driver for JDBC]Unhandled token type: Unknown token:0x01



CAUSE
The COMPUTE clause and the COMPUTE BY clause are not supported in Microsoft SQL Server 2000 Driver for JDBC.

Note The 2.x version of DataDirect SQL Server Driver for JDBC is licensed from DataDirect Technologies and was released as Microsoft SQL Server 2000 Driver for JDBC.



RESOLUTION
To resolve this problem, you must have the 3.x version of the DataDirect SQL Server Driver for JDBC. With the 3.x version of the DataDirect SQL Server Driver for JDBC driver supports the COMPUTE clause and the COMPUTE BY clause.

For more information about how to obtain the latest version of DataDirect SQL Server Driver for JDBC, visit the following DataDirect Technologies Web site:

http://www.datadirect-technologies.com/

Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information. The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Keywords: kberrmsg kbtsql kbdatabase kbjdbc kbprb kbdriver kbquery KB827969

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.