What does it mean "This command is not supported in the prepared statement protocol yet "?

[DarioBon]

I use to be able to run SQL statements like this in RMarkdown on RStudio Cloud

```{sql, connection=con}
USE dnName

But now I get following error:

Error in new_result(connection@ptr, statement, immediate) :
nanodbc/nanodbc.cpp:1412: 00000: [RStudio][MySQL] This command is not supported in the prepared statement protocol yet
Failed to execute SQL chunk

What does it mean?

[jforest]

Hi @DarioBon

Without more detail there isn't too much I can say here, but this seems pretty similar linux - MySQL load data: This command is not supported in the prepared statement protocol yet - Stack Overflow

Does that help at all?

-Josh

[DarioBon]

Not really, but I'm happy to provide a reproducible example if you can advise how.