[ODBC-28] ODBC driver does not support dynasets Created: 2015-11-13  Updated: 2021-03-04  Resolved: 2021-03-04

Status: Closed
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: 1.0.5
Fix Version/s: N/A

Type: New Feature Priority: Minor
Reporter: Erik Cederstrand Assignee: Lawrin Novitsky
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

Windows 10


 Description   

I'm trying to use a commercial application with the MariaDB ODBC driver. When the application attempts to use the ODBC connection, I get the error message "ODBC driver does not support dynasets".

According to the developers of the application, they use dynasets for Access and MSSQL databases, but not for MySQL, so I assume the application simply probes the connection for functionality (I can't get access to the source code, unfortunately).

So bending the truth just a wee bit here and answering "Yes" would probably let me use the MariaDB driver, without having to implementing full support for dynasets. Something later on could then answer "Just kidding!" if the user actually tries to use dynasets.

 Comments   
Comment by Lawrin Novitsky [ 2016-01-08 ]

Heelo Erik and thank you for your bug report!

Most probably your application misses SQL_SO_KEYSET_DRIVEN in SQL_SCROLL_OPTIONS.information returned by our connector.
The proper they would be to either implement it, or to introduce connections string option telling driver to lie to applications(on their own responsibility).

It's not big problem to add such option, in case it really helps. But I would prefer you first verify it does. Are you able to build MariaDB Connector/ODBC? All you need is to find in ma_info.c
case SQL_SCROLL_OPTIONS:
{
SQLUINTEGER BitMask= SQL_SO_FORWARD_ONLY | SQL_SO_DYNAMIC | SQL_SO_STATIC;

and add "| SQL_SO_KEYSET_DRIVEN" after SQL_SO_STATIC
Then build connector library and substitute installed library with your patched one. If it works with your application, I don't mind to add aforementioned connection string option.

If you can't do that - let me know, and I will build and attach dll here to the bug page.

Best regards,
Lawrin

Comment by Lawrin Novitsky [ 2021-03-04 ]

Since there is no feedback, I am closing this issue

Generated at Thu Feb 08 03:25:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.