Easysoft ODBC-ODBC Bridge

Why do I get "Incorrect Syntax near the Keyword 'by'" error message when calling SQLDescribeParam in the MS SQL Server ODBC driver?

Article:
00989
Last Reviewed:
27th November 2008
Revision:
2

When calling SQLDescribeParam in the MS SQL Server ODBC driver you get an error return with the diagnostic text:

"Incorrect Syntax near the Keyword 'by'"

This was a bug in MDAC 2.6 and is fixed in MDAC 2.6 sp1.

It happens if you have a column named "c", "ca" or "cas" and you call SQLDescribeParam because the driver is checking for a CASE statement and does the check incorrectly.

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.