Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

ERROR: Prepared statement needs to be re-prepared

vmmaldon
5 - Atom

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.

 

vmmaldon_0-1636482516682.png

 

1 REPLY 1
Thableaus
17 - Castor
17 - Castor

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-t... - would this make any sense as an answer to your problem?


Cheers,

Labels