MySQL Forums
Forum List  »  Connector/ODBC

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

Dear,

Could someone help me?

i have Sqlpassthru as below:
eg.

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


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


Sorry, only registered users may post in this forum.

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.