MySQL Forums
Forum List  »  Connector/ODBC

Re: Batched statements in MS Excel 2016 query definition
Posted by: Bogdan Degtyariov
Date: July 07, 2020 01:53AM

Setting the option should work if the statements are separated by semicolon.
However, a good question is what the actual batch statement look like.
You can find it out by enabling the debug option Debug -> [x] Log queries to %TEMP%\myodbc.sql

This should only be used as a temporary measure because all queries from this particular DNS will be available for reading inside the %TEMP% directory.

Options: ReplyQuote


Subject
Written By
Posted
Re: Batched statements in MS Excel 2016 query definition
July 07, 2020 01:53AM


Sorry, only registered users may post in this forum.

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.