Am Montag, dem 26.05.2025 um 02:15 +0000 schrieb Lawrin Novitsky via discuss:
Hi!
The driver always returns default types for parameters as MariaDB server doesn't not provide metadata for them, and the client has no means to know real parameter types.
Thanks. That's a pity. I'll make the user specify the parameter types then. Cheers Volker
Best regards, Lawrin From: Volker Wysk via discuss <discuss@lists.mariadb.org> Sent: Tuesday, May 13, 2025 10:19 AM To: MariaDB Discuss <discuss@lists.mariadb.org> Subject: [MariaDB discuss] ODBC driver and SQLDescribeParam()
Hi!
I'm working on a high-level database access library, using UnixODBC, MariaDB and the MariaDB-ODBC-driver. I's for the Mercury programming language.
The MariaDB ODBC 3.1.4 Driver doesn't work when using SQLDescribeParam(). This ODBC function is used to query metadata for the parameters of a prepared SQL statement (one which includes question marks). Such as the type of the parameter. The driver returns SQL_VARCHAR for all parameters, regardless of the actual type of the parameter.
I've installed and tried the newest MariaDB ODBC 3.2.5 Driver, and there's no difference. It also reports SQL_VARCHAR for all parameters. But I'm not 100% sure I've installed the newer driver correctly.
What is the state of affairs about MariaDB and ODBC parameter metadata?
Thanks, Volker _______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org _______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org