Re: Sqlpassthru error after update to Mysql 8
... CONTINUE..
Code write in VFP9 SP2
[ USING 5.3 ]
lcStringConn="Driver={MySQL ODBC 5.3 ANSI Driver};Port=3306"+;
";Server="+lcServer+;
";Database="+lcDatabase+;
";Uid="+usr+;
";Pwd="+pswd
[ USING 8.0 ]
lcStringConn="Driver={MySQL ODBC 8.0 ANSI Driver};Port=3306"+;
";Server="+lcServer+;
";Database="+lcDatabase+;
";Uid="+usr+;
";Pwd="+pswd
ServerStrConn=Sqlstringconnect(lcStringConn)
SqlCommand="Select * from Table_a where Key1=?Param_1 and Key2=?Param_2"
SQLOK=SQLEXEC( ServerStrConn, SQLCommand )
this SQLOK return 1 (no problem), but no result return if i use 8.0, supposed to return some record accordance to the parameters.
i have check in the database, no error and return some record.
but if i use 5.3, it runs perfectly...
any idea?
Do need help...
thanks.
Subject
Written By
Posted
Re: Sqlpassthru error after update to Mysql 8
October 23, 2018 05:12AM
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.