Re: visual studio 2015 and MySQL stored procedure

[Bogdan Degtyariov]

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.