DSXchange

Hi All,

I am connecting to MYSQL database through ODBC connector.
I managed to connect to MYSQL database but everytime I execute a select query it gives an error:
ODBC:1615 [IBM(DataDirect OEM)][ODBC MySQL Wire Protocol driver] [MYSQL]Prepared statement needs to be re-prepared.

I checked with MYSQL DBAs and they informed me the same query is running fine from all other clients. They have asked me to check ODBC connection.

Does anyone know what should be checked and how to troubleshoot/resolve this error?

Thanks for the help in advance.

Regards,
PR

That sounds like a bug with the connector to me, in your shoes I'd contact support or check for patches.

Hi,

I found this MYSQL bug which address the issue you're seeing. This was experienced at several version of Mysql 5.1.x.

http://bugs.mysql.com/bug.php?id=42041

Some suggestion on above bug report was changing Mysql database settings appear to help resolving the issue:

table_open_cache 128=>16384
table_definition_cache 1024=>16384
tmp_table_size 32M=>64M
join_buffer_size 256k=>512k

I hope this helps

Hi,

Thanks for the information.

I had checked this but since this query works fine from all other clients, my DBAs think it is ODBC driver issue.

When we fire this query on other clients, it gives us desired output.

Regards,
PR

Forgot to mention MYSQL version. It is 5.6

Driver issue, connector issue... contact support.