MySQL Forums
Forum List  »  Connector/ODBC

Sqlpassthru error after update to Mysql 8
Posted by: Harry Buana
Date: October 23, 2018 02:23AM


Could someone help me?

i have Sqlpassthru as below:

SqlCommand="Select * from Table_a where Key1=?Param_1 and Key2=?Param_2"

After i update to mysql 8 (from 5.8) it suddenly not working, it return 0 result, supposed to return 1 record. the connection is 1 (success), but seems the parameter is not working.

i try around like this :

SqlCommand="Select * from Table_a where Key1='"+Param_1 +"' and Key2='"+Param_2+"'"

suddenly it work normal.
Is there any thing i should change/set ?
i'm not able to change the code all.

Thanks in advance.

Options: ReplyQuote

Written By
Sqlpassthru error after update to Mysql 8
October 23, 2018 02:23AM

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.