MySQL Forums
Forum List  »  Connector/C++

Re: Load Data Local Infile with Connector/C++
Posted by: Ben Lu
Date: August 16, 2018 02:04PM

Thanks for the reply @Luis! Not sure if I understood the issue correctly. So, in the my.ini file, I tried to add "local-infile=1" under [mysql] and [mysqld] and also "local-infile=1" or "loose-local-infile=1" under [client], but that didn't help. Despite that the value of global variables local_infile is ON, I still got the same error "The used command is not allowed with this MySQL version" when running the query from my app via ODBC 8.0. But running the same query directly off Workbench client worked. I think it is likely an ODBC drive issue but the error message seems to indicate that local_infile was disabled...

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Load Data Local Infile with Connector/C++
682
August 16, 2018 02:04PM
626
September 19, 2018 09:09AM


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.