Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-332

Old DSN cannot be find to import when old ODBC version is uninstalled and new version installed in Excel

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: None
    • Fix Version/s: N/A
    • Component/s: General
    • Labels:
      None

      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:

        Attachments

        1. image-2021-08-03-09-44-59-836.png
          image-2021-08-03-09-44-59-836.png
          29 kB
        2. screenshot-1.png
          screenshot-1.png
          29 kB
        3. screenshot-2.png
          screenshot-2.png
          16 kB
        4. screenshot-3.png
          screenshot-3.png
          9 kB
        5. screenshot-4.png
          screenshot-4.png
          40 kB
        6. screenshot-5.png
          screenshot-5.png
          5 kB

          Activity

            People

            Assignee:
            Lawrin Lawrin Novitsky
            Reporter:
            anel Anel Husakovic
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.