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

SQLForeignKeys reports error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.2.4
    • 3.2.5
    • General
    • None
    • Windows OS

    Description

      The ODBC function call SQLForeignKeys https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlforeignkeys-function?view=sql-server-ver16 generates the following error with MariaDB 3.2 ODBC Driver.

      General error 42000 (1064)--[ma-3.2.4][10.11.6-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, KEY_SEQ, PKTABLE_NAME' at line 1

      The following is DataFlex code using the Windows API function

      Move (SQLForeignKeys(hStmt,0,SQL_NTS,0,SQL_NTS,0,SQL_NTS,0,SQL_NTS,AddressOf(sFromSchema),SQL_NTS,AddressOf(sFromTable),SQL_NTS)) to iResult

      The error is not generated using the 3.1 ODBC driver

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            DataFlex63 Vincent Oorsprong
            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.