OFF2000: Error Message: "The SQL 0104-Token* Was Not Valid" Running AS/400 Query (249313)


The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Word 2000
This article was previously published under Q249313

SYMPTOMS

When you run a data query, the following error message may appear:
The SQL 0104-token* was not valid.

CAUSE

The problem occurs if the following are true:
  • You are running a data query in one of the programs listed at the beginning of this article. -and-

  • You are trying to query data on an IBM AS/400 system. -and-

  • You are using the IBM ODBC data source administrator driver for the AS/400.

RESOLUTION

The following Web page on the IBM Web site contains information about how to resolve this issue:

http://www-1.ibm.com/servlet/support/manager?rt=0&rs=0&org=as400&doc=C8A5AA1D94D3425D862565C2007CD244

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.

MORE INFORMATION

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.


For information about how to contact IBM, query in the Knowledge Base for one of the following articles:

65416 Hardware and Software Third-Party Vendor Contact List, A-K

60781 Hardware and Software Third-Party Vendor Contact List, L-P

60782 Hardware and Software Third-Party Vendor Contact List, Q-Z

Modification Type:MajorLast Reviewed:10/7/2003
Keywords:kbfix kbprb KB249313
©2003 Microsoft Corporation. All rights reserved.