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

MS Access won't work with the linked table if best row id is BIGINT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.1.21, 3.2.5
    • 3.2.6, 3.1.22
    • General
    • None

    Description

      The table can be linked, but the rows will be showed as "#Deleted".

      There are 2 things in here - why it does not work in normal mode, and while it does not work with NOBIGINT option that supposed to make the column to look like normal int column. The latter is easier - SQLColumns returns SQL_BIGINT data type for such column, and if change this to SQL_INTEGER NOBIGINT fixes the issue.

      The former is more complicated and appears to be resembling ODBC-360. Access reads bigint values as SQL_WCHAR. Not sure why atm but I guess if we make it use different type this will solve the issue.

      Attachments

        Issue Links

          Activity

            People

              Lawrin Lawrin Novitsky
              Lawrin Lawrin Novitsky
              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.