[ODBC-332] Old DSN cannot be find to import when old ODBC version is uninstalled and new version installed in Excel Created: 2021-08-03  Updated: 2021-08-03  Resolved: 2021-08-03

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

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

Attachments: PNG File image-2021-08-03-09-44-59-836.png     PNG File screenshot-1.png     PNG File screenshot-2.png     PNG File screenshot-3.png     PNG File screenshot-4.png     PNG File screenshot-5.png    

 Description   

I'm not sure is this related to ODBC or Excel, but let me report.

I have first created DSN with "ODBC Data Source (32/64 bit) " and installed from https://downloads.mariadb.org/connector-odbc/ MariaDB ODBC 3.13.
After that I have removed the old version and installed from source (latest one with patch of interest).
During installation I clicked option "Allow old user DNS the same name ..." (or something similar).
Now I'm not able to remove old DSN even when ODBC Data Source app is started as administrator:

And reason for that is that is using 32 bit version.
There is also 64 bit version where we can see that DSN exists and can be removed

However, when I tried to look for DSN there are 2 ways (ODBC-326):

  • Import from Data Connection Wizard
  • Import from Microsoft Query
    there is no DSN for mariadb-server

1. Data Connection Wizard

2. Microsoft Query

Additionally, we cannot add new DSN if old DSN exists (no MariaDB ODBC option to use).
If we remove old version, we can add new one:

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

I don't think there is anything wrong here. There 32 and 64b drivers. There are ODBC DS administrator for 32b and 64b. If drivers have been installed for both architectures, DSN may exist for both. Excel usually is 32b application, and thus looks for 32b Drivers/DSN's. Thus 64b driver/dsn is not visible. Or vice versa.

Comment by Anel Husakovic [ 2021-08-03 ]

Lawrin ok, how to specify , when building from source, 32b MariaDB ODBC driver to be built?
I have built only for 64 bit version (from source - latest patch).

Comment by Anel Husakovic [ 2021-08-03 ]

Found use -A Win32 with cmake.
However, update of documentation would be great.

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