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

ID: Q124316

The information in this article applies to:

Microsoft Open Database Connectivity, version 2.0

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 :
Version : WINDOWS:2.0
Platform : WINDOWS
Issue type :