MySQL Forums
Forum List  »  Connector/ODBC

Batched statements in MS Excel 2016 query definition
Posted by: Ali Cameron
Date: June 18, 2020 08:47PM

Hi,

I have tried a DSN with the 'Allow multiple statements' option set as well as a DSN-less connection using the 'option=67108864' flag set, and in both cases the driver returns a syntax error which suggests that batching is disabled (error message quotes the text following the first semicolon).

Are multiple statements separated by semicolons supported by Excel 2016 MS query?

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Batched statements in MS Excel 2016 query definition
June 18, 2020 08:47PM


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.