ERROR: Prepared statement needs to be re-prepared

Question

Hello,

I am getting the following error when trying to bring in data from a view table in SQL:

Error: Input Data (2): Error SQLExecute: [MySQL][ODBC 8.0(a) Driver][mysqld-5.5.5-10.2.24-MariaDB]Prepared statement needs to be re-prepared

I am only experiencing this issue with views and can access tables with no problem.

TIA.

Thableaus · Answer

Hey @vmmaldon

Whenever I have ODBC driver errors, I usually google the error because it's probably related to the database connection you have.

With that being said, I found this on Stack Overflow - https://stackoverflow.com/questions/4380813/how-to-get-rid-of-mysql-error-prepared-statement-needs-to-be-re-prepared - would this make any sense as an answer to your problem?

Cheers,