PRB: "Unhandled Token Type" Error Message When You Run a Transact-SQL Statement That Contains a COMPUTE Clause (827969)
The information in this article applies to:
- Microsoft SQL Server 2000 Driver for JDBC
- Microsoft SQL Server 2000 (all editions)
SYMPTOMSWhen 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 CAUSEThe 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.RESOLUTIONTo 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: 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.
| Modification Type: | Major | Last Reviewed: | 10/29/2003 |
|---|
| Keywords: | kbJDBC kberrmsg kbTSQL kbDriver kbQuery kbDatabase kbprb KB827969 kbAudDeveloper |
|---|
|