[ODBC-326] Connecting Excel with MariaDB through Microsoft Query - String data right truncated Created: 2021-07-01  Updated: 2021-08-03  Resolved: 2021-08-02

Status: Closed
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: 3.1.13
Fix Version/s: 3.1.14

Type: Bug Priority: Major
Reporter: Anel Husakovic Assignee: Lawrin Novitsky
Resolution: Fixed Votes: 0
Labels: None
Environment:

Windows

Attachments: PNG File image-2021-07-01-20-26-09-443.png    
Issue Links:
Problem/Incident
causes ODBC-333 Excel cannot recognize ODBC data Closed
Relates
relates to ODBC-244 Microsoft Excel 365 ODBC Navigator ca... Closed

 Description   

When following this link:
https://www.cdata.com/kb/tech/mariadb-odbc-excel-query.rst
Data -> From other sources -> From Microsoft Query the error is generated
"String data right truncated"

While when doing Data -> From other sources -> From Data Connection Wizard -> ODBC DSN it works, like here https://dba.stackexchange.com/questions/192083/excel-query-using-mariadb-odbc-driver

Is this something specific to "Microsoft Query" GUI or on MariaDB connector side?

 Comments   
Comment by Lawrin Novitsky [ 2021-08-02 ]

The problem was in incorrect processing of SQL_C_DEFAULT bind type for result columns, used by MS query to read API call results.

Comment by Anel Husakovic [ 2021-08-03 ]

Lawrin This is a regression - ODBC-333 created.
Update: I can confirm that now option Data->From Other sources-> From Microsoft Query works well (as well as option Data->From other source -> Data wizard.
Thanks Lawrin.

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