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

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.

• About Easysoft

• Contact us
• About us
• Clients
• Blog
• Careers

• Products

• ODBC drivers
• JDBC drivers
• Bridges and gateways
• In development

• Services

• Consultancy
• Training
• Custom development

• Licensing

• Product licenses
• Prices

• Support

• Support home
• Solution wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer area
• Client applications

• Legal

• Privacy statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
•