MySQL :: Re: Mysql ODBC 8.0.15 SQLFetch returns SQL_NO_DATA for a Select query with where clause if one of the selected fields is blob. Works fine for 5.3.6

New Topic

Re: Mysql ODBC 8.0.15 SQLFetch returns SQL_NO_DATA for a Select query with where clause if one of the selected fields is blob. Works fine for 5.3.6

Posted by: Bogdan Degtyariov
Date: February 20, 2019 11:18PM

Hi everyone,

This is the problem in Connector/ODBC 8.0.
There is a bug report for it here:

https://bugs.mysql.com/bug.php?id=93895

We are currently working on fixing it.
A workaround for the problem is to use the client-side statements.
It can be enabled through the connection string: NO_SSPS=1 or through the GUI dialog in ODBC Admin: Details >> Misc >> [x] Prepare statements on client.

Sorry for inconvenience.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

Mysql ODBC 8.0.15 SQLFetch returns SQL_NO_DATA for a Select query with where clause if one of the selected fields is blob. Works fine for 5.3.6

Sunny Taksande

February 18, 2019 11:54PM

Re: Mysql ODBC 8.0.15 SQLFetch returns SQL_NO_DATA for a Select query with where clause if one of the selected fields is blob. Works fine for 5.3.6

Peter Brawley

February 19, 2019 11:57AM

Re: Mysql ODBC 8.0.15 SQLFetch returns SQL_NO_DATA for a Select query with where clause if one of the selected fields is blob. Works fine for 5.3.6

Sunny Taksande

February 20, 2019 06:22AM

Re: Mysql ODBC 8.0.15 SQLFetch returns SQL_NO_DATA for a Select query with where clause if one of the selected fields is blob. Works fine for 5.3.6

Peter Brawley

February 20, 2019 11:07AM

Re: Mysql ODBC 8.0.15 SQLFetch returns SQL_NO_DATA for a Select query with where clause if one of the selected fields is blob. Works fine for 5.3.6

Bogdan Degtyariov

February 20, 2019 11:18PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.