Sqlpassthru error after update to Mysql 8

[Harry Buana]

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.