MSQuery Err Msg: Illegal Character Detected With DEC Rdb

 Last reviewed: September 12, 1996
Article ID: Q121469
The information in this article applies to:
  • Microsoft Query for Windows, version 1.0

SUMMARY

In Microsoft Query version 1.0, you may receive the following error message: 

     % SQL-F-ILLCHAR, Illegal Character Detected
This error message may be displayed if you query a DEC Rdb data source using any of the following ODBC drivers:

- DEC ODBC driver, version 1.10 - Oracle ODBC driver, version 2.0

If you are using version 1.01.2115 of the DEC ODBC driver, you will receive the following error message: 

     & SQL-F-ILLCHAR, Illegal Character Detected

WORKAROUND

There is a setting in the [DEC ODBC Driver] section of the WIN.INI file that allows you to enable or disable support for control characters. To obtain these settings, contact DEC Technical Support at (800)354-9000.

MORE INFORMATION

The DEC ODBC (Open Database Connectivity) driver is manufactured by Digital Equipment Corporation, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

Microsoft Query sends SQL statements containing control characters and when DEC SQL receives an SQL statement with control characters, it sends back the above error message. Version 1.10 of the DEC ODBC Driver has a feature that will strip out any control characters in an SQL statement before it sends the statement to an Rdb database.

KBCategory: kb3rdparty kbnetwork kberrmsg
KBSubcategory: xlquery

Additional reference words: 5.00 third-party



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.