MySQL Forums
Forum List  »  Connector/ODBC

Re: visual studio 2015 and MySQL stored procedure
Posted by: Bogdan Degtyariov
Date: March 18, 2019 11:38PM

Hi David,

The errors like this usually indicate that a parametrized query is missing one or more bind parameters, which should be done using SQLBindParameter().
The number parameter markers should be equal to SQLBindParameter() calls.

For instance:

a query like this:

SELECT col1, col2, str_to_Date(lic.exp_date,'%m/%d/%Y') FROM lic WHERE id = ? and create_date > ?

must has two parameters. If parameters data is not provided the driver won't be able to figure out how to execute the query.

Options: ReplyQuote

Written By
Re: visual studio 2015 and MySQL stored procedure
March 18, 2019 11:38PM

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.