MySQL Forums
Forum List  »  Connector/ODBC

Re: Issues with bound parameters using ODBC Connector 8.4 & 9.0
Posted by: Bogdan Degtyariov
Date: July 08, 2024 12:24AM

Hi Jon,

Thanks for the detailed description of the problem.

The Connector/ODBC is linked against MySQL Client library of the same version.
In the version 8.1 and newer the MySQL Client library had changes in the protocol regarding named parameters including (but not limited to) introducing of new parameter buffer types.

Therefore, when a newer ODBC driver such as 8.4 or 9.0 is connecting to an older server such as 5.7.44 or 8.0.37 the server might return errors like "No data supplied for parameters in prepared statement" or "Using unsupported buffer type:".

The easiest way to work around these issues would be preparing the statements on the client side and disabling the server side prepared statements (SSPS). This can be done in one of the following ways:

- adding NO_SSPS=1 to the ODBC connection string inside your application

- updating the DSN (in odbc.ini file) by adding a new line "NO_SSPS=1". This
is normally done in non-Windows systems as Windows keeps ODBC options in
the registry instead of files (unless a file DSN is used).

- ticking a box in ODBC driver GUI dialog:
Details >> Misc >> [x] Prepare statements on the client

Otherwise, if using SSPS is required, the only way to go would be either downgrading the ODBC driver version to 8.0.x or upgrading MySQL Server to 8.4.0/9.0.0.

--
Best regards,
Bogdan Degtyariov

Options: ReplyQuote


Subject
Written By
Posted
Re: Issues with bound parameters using ODBC Connector 8.4 & 9.0
July 08, 2024 12:24AM


Sorry, only registered users may post in this forum.

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.