Microsoft KB Archive/124316

= BUG: Use of Vertical Bar (|) Generates Syntax Error =

Article ID: 124316

Article Last Modified on 7/27/2001

-

APPLIES TO


 * Microsoft Open Database Connectivity 2.0

-



This article was previously published under Q124316



BUG# QJET: 11 (2.00.2317)



SYMPTOMS
When you execute a SELECT, INSERT, UPDATE or DELETE queries with a vertical bar (|) contained in a character string, you receive an error that there is a syntax error in string in query expression.

For example, consider table test created like:

CREATE TABLE test (t text(20))

Then executing any of the following, INSERT INTO test VALUES('|') DELETE FROM test WHERE t='|' UPDATE test SET t='|' will return an error, with

SQLSTATE=S1010 and szErrorMsg="[Microsoft][ODBC Access 2.0 Driver]Syntax error in string in query expression"



STATUS
Microsoft has confirmed this to be a problem in ODBC Access Driver version 2.00.2317. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: 2.00.2317 ODBC MFC MSVC VISUAL C++ Windows NT

Keywords: kbbug KB124316

-

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

© Microsoft Corporation. All rights reserved.