BUG: Syntax Error Using ESQLC DESCRIBE and SQLDA

ID: Q153313

The information in this article applies to:

Microsoft Embedded SQL for C Programmer's Toolkit, version 6.5

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. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: ESQL/C ESQL-C

Keywords : kbbug6.50
Version : 6.5
Platform : WINDOWS
Issue type :