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

ID: Q249313

The information in this article applies to:

Microsoft Office 2000
Microsoft Excel 2000
Microsoft Word 2000

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.

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

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

RESOLUTION

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

http://d02xwas002.southbury.ibm.com/support/support_doc/as400/s0001/body/14724.shtml

The third-party contact information included in this article is provided to help you find the technical support you need. This contact information is subject to change without notice. Microsoft in no way guarantees the accuracy of this third-party contact information.

MORE INFORMATION

The third-party products discussed in this article are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

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

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

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

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

Additional query words: OFF2000

Keywords : kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb