MySQL Forums
Forum List  »  Connector/ODBC

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

... 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.

Options: ReplyQuote


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.