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...
Subject
Views
Written By
Posted
2070
June 28, 2018 03:26PM
824
August 15, 2018 08:05AM
949
August 16, 2018 05:25AM
Re: Load Data Local Infile with Connector/C++
940
August 16, 2018 02:04PM
1034
August 27, 2018 05:01AM
838
August 27, 2018 07:04AM
909
August 27, 2018 07:47PM
827
August 27, 2018 09:41PM
808
September 19, 2018 09:09AM
949
August 21, 2018 04:34AM
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.