MySQL Forums
Forum List  »  Microsoft Access

ODBC Call Failed error When using Parameter
Posted by: Craig Froehlich
Date: November 14, 2012 07:59AM

I am trying to setup an MS Access frontend to a MySQL database for reporting and query purposes. One of the reports, accepts a few parameters and then runs a query with those parameters to return results. I always receive and ODBC Call Failed error. If I manually write the query with the value in the parameter it works fine. I've also been able to determine that this will work if the field I am comparing is integer, but not varchar. So it seems to me that the query being sent is malformed, but I'm not able to determine how. Suggestions?

Options: ReplyQuote

Written By
ODBC Call Failed error When using Parameter
November 14, 2012 07:59AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.