[ODBC-333] Excel cannot recognize ODBC data Created: 2021-08-03  Updated: 2021-08-04  Resolved: 2021-08-04

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

Type: Bug Priority: Critical
Reporter: Anel Husakovic Assignee: Lawrin Novitsky
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Windows

Attachments: PNG File image-2021-08-03-10-11-37-088.png     PNG File image-2021-08-03-10-13-00-174.png     PNG File image-2021-08-03-10-14-01-252.png     PNG File image-2021-08-03-10-14-14-308.png     PNG File screenshot-1.png    
Issue Links:
Problem/Incident
is caused by ODBC-326 Connecting Excel with MariaDB through... Closed

 Description   

I used latest patch for ODBC driver and Excel cannot recognize DSN,

  • DSN created
  • Open Excel, Data ->From Other Source -> From Microsoft Query:
  • Open Excel -> Data -> From Other Source - >From Data Connection Wizard -( Note this worked before ODBC-326)

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

Your Excel is most probably 32b. Can that be caused by this?

Comment by Lawrin Novitsky [ 2021-08-03 ]

More precisely - if Excel is 32b application, then there is no problem here and everything is as expected. And most probably that is the case(that Excel is 32b)

Comment by Anel Husakovic [ 2021-08-03 ]

Yes, I'm confirming it was 64b version of a driver.
Now I have installed 32b version of driver (would be good to update documentation), when building from source use -A Win32 with cmake (Visual Studio 2019).
And now I have both version

And I can confirm that this ODBC can be closed.
Thanks Lawrin .

Comment by Lawrin Novitsky [ 2021-08-04 ]

Thanks, Anel, for confirmation.

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