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?

When calling SQLDescribeParam in the Microsoft 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

• Products
  • Easysoft ODBC-ODBC Bridge
• Databases
  • Microsoft SQL Server

Knowledge Base Feedback

* Did this content help you?

Yes No Maybe

* Please select one option based on your first choice:

I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

Suggest new content or let us know how we can improve this content:

(* Required Fields)

• About Easysoft

• Contact Us
• About Us
• Clients
• Upgrade Offer
• 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.

• 
• 
• 
•