KNOWLEDGE BASE

Error code: B19090E0 [MYSQL][ODBC 8.0(w) Driver][mysqld-5.7.32]This Command Is Not Supported In The Prepared Statement Protocol Yet


Published: 06 Oct 2021
Last Modified Date: 07 Oct 2021

Issue

When connecting to a SingleStore MYSQL data source in Tableau Desktop this command is not supported error presents. Exact error text is below for reference:
An error occurred while communicating with the Singlestore data source "XXXXX"
Bad connection: Tableau could not connect to the data source.
Error code: B19090E0
[MYSQL][ODBC 8.0(w) Driver][mysqld-5.7.32]This command is not supported in the prepared statement protocol yet
Unable to connect to the XXX server "10.x.x.x.x". Check that the server is running and you have access privileges to the requested database.

Steps to reproduce this error:
In Tableau desktop, clicking or dragging a table from the left side pane, adds a box to the model, but it does not load any columns or show any sample data. It results in the error above.

Environment

  • Tableau Desktop
  • SingleStore

Resolution

Install the MySQL ODBC 5.3 driver.

Cause

Singlestore does not support MYSQL 8.0 driver and the MYSQL driver version needs to be reverted back to the MySQL ODBC 5.3 driver version to work with Singlestore MYSQL databases.
Did this article resolve the issue?