getting ODBC 1615 error while connecting to MYSQL database

Pravenai · Post by **Pravenai** » Fri Jan 23, 2015 9:27 am

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

chulett · Post by **chulett** » Fri Jan 23, 2015 10:55 am

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

rjdickson · Post by **rjdickson** » Fri Jan 23, 2015 1:55 pm

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

Pravenai · Post by **Pravenai** » Fri Jan 23, 2015 1:58 pm

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

Pravenai · Post by **Pravenai** » Fri Jan 23, 2015 1:59 pm

Forgot to mention MYSQL version. It is 5.6

chulett · Post by **chulett** » Fri Jan 23, 2015 4:27 pm

Driver issue, connector issue... contact support.