Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-123444

regression: ODBC connection strings no longer work with QSqlDatabase::setDatabaseName()

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • P1: Critical
    • 6.7.1, 6.8.0 FF
    • 6.7.0 RC, 6.7.0, 6.7
    • SQL Support
    • None
    • All
    • 9873f4b28 (dev), 8f25cdc94 (6.7)

    Description

      ODBC connection strings such as the following example no longer work when passed to QSqlDatabase::setDatabaseName():

      DRIVER={ODBC Driver 18 for SQL Server};Server=localhost;Port=1433;Database=test;UID=gus;PWD=TopSecret123!;Encrypt=no;

      The regression is caused by Change-Id: I1df638194067af5df94a34009e1547886fdf928c for QTBUG-122642 which introduces quoting of individual parameters. However, this change does not take into account the fact that the database name parameter may be an ODBC connection string containing multiple parameters delimited by ;. 

       

       

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. PYSIDE-2744 The script terminates unexpectedly with exit code 3221225477 upon attempting to import QSqlDatabase.

          • Not Evaluated - Not yet evaluated/prioritized
          • Closed
          resulted from

          Bug - A problem which impairs or prevents the functions of the product. QTBUG-122642 The SQL QODBC driver implementation fails to escape passwords set with setPassword(...) when using special characters.

          • P2: Important - Urgent, should be fixed, but will not stop the release.
          • Closed
          For Gerrit Dashboard: QTBUG-123444
          # Subject Branch Project Status CR V
          552204,3 SQL/ODBC: don't escape a driver string dev qt/qtbase Status: MERGED +2 0
          553133,2 SQL/ODBC: don't escape a driver string 6.7 qt/qtbase Status: MERGED +2 0

          Activity

            People

              chehrlic Christian Ehrlicher
              mabrand Mark Brand
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes