Loading

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

Data pubblicazione: Mar 6, 2025
Descrizione
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.

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.
Risoluzione
Install the MySQL ODBC 5.3 driver.
Numero articolo Knowledge

001534433

 
Caricamento
Salesforce Help | Article