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

Unable to get data from tables with VarChar or Char as primary keys

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 3.1.15
    • None
    • General
    • None
    • MariaDB back-end; MS Access front-end; Windows 10; Office version: version 2205 (Build 15225.20092)

    Description

      Showed up this morning. Enterprise wide. Get "deleted" as field values. Verified data is still available through database editor. But, ODBC connector seems to be invalid now for any tables using Char or VarChar as primary keys. Confirmed combo primary keys still work as long as primary keys are any integers. Possible windows/office updates the cause, but still an issue between MS and MariaDB (seems to also affect Oracle db's: https://answers.microsoft.com/en-us/msoffice/forum/all/ms-access-displays-deleted-in-every-field-for/593e5f12-3cbd-414e-841c-9df612504d3c?page=2

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. ODBC-458 MS Access won't work with the linked table if best row id is BIGINT

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Lawrin Lawrin Novitsky
              Dallas A Dallas Ailes
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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