Knowledge Base

BUG: Syntax Error Using ESQLC DESCRIBE and SQLDA

PSS ID Number: 153313

Article Last Modified on 3/14/2005

The information in this article applies to:

This article was previously published under Q153313

SYMPTOMS

The DESCRIBE statement may generate the following error when it tries to populate a SQLDA that is using a Prepared Statement containing a parameter marker (?).
Error Handler called:
SQL Code = -170
SQL Server Message 170: 'Line 1: Incorrect syntax near '?'.'

The same error may also occur if a PREPARE INTO :sqlda statement is used.

WORKAROUND

Rather than use DESCRIBE or PREPARE INTO, populate the SQLDA manually in the program.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Embedded SQL for C Programmer's Toolkit version 6.5.

Additional query words: ESQL/C ESQL-C

Keywords: kbBug KB153313
Technology: kbAudDeveloper kbSQLEmCPTKSearch kbSQLServSearch


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.