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

The SQL QODBC driver implementation fails to escape passwords set with setPassword(...) when using special characters.

    XMLWordPrintable

Details

    • Windows
    • 000d462bf (dev), 0b5b6e7db (6.7), 38277a88f (dev), d10cba961 (6.9), e43f6d708 (6.8), d2cd406b3 (dev), deda96666 (6.10), bae157261 (6.9), 022bb08ac (tqtc/lts-6.8)

    Description

      The SQL QODBC driver implementation fails to escape passwords set with setPassword(...). Authentication fails when using a password with special characters like ";". However, when wrapping the password inside { }, authentication succeeds.

      Proper escaping should be done in the driver implementation.

      To reproduce the issue:

      1. Create a test database with Microsoft SQL Server.
      2. Ensure that your database accepts SQL Server and Windows Authentication mode.
      3. Create a user and ensure that their password contains ";".
      4. Edit the values in the attached example project to match your database information and user credentials.
      5. Run the attached example project.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. QTBUG-137010 QSqlDatabase::setPassword() is not working for Microsoft Access database (mdb/accdb).

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

          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

          Bug - A problem which impairs or prevents the functions of the product. QTBUG-123444 regression: ODBC connection strings no longer work with QSqlDatabase::setDatabaseName()

          • P1: Critical - Urgent and Important, will STOP the release if matched with set FixVersion field. This includes regressions from the last version that are not edge cases; Data loss; Build issues; Flaky tests; All but the most unlikely crashes/lockups/hanging; Serious usability issues and embarrassing bugs & Bugs critical to a deliverable. This is the highest possible priority for requirements.
          • Closed
          For Gerrit Dashboard: QTBUG-122642
          # Subject Branch Project Status CR V
          543254,2 SQL/ODBC: escape values in connection string dev qt/qtbase Status: MERGED +2 0
          544775,2 SQL/ODBC: escape values in connection string 6.7 qt/qtbase Status: MERGED +2 0
          603103,4 SQL/ODBC: escape values in connection string dev qt/qtbase Status: MERGED +2 0
          618974,2 SQL/ODBC: escape values in connection string 6.9 qt/qtbase Status: MERGED +2 0
          619168,2 SQL/ODBC: escape values in connection string 6.8 qt/qtbase Status: MERGED +2 0
          646936,3 SQL/ODBC: fix escaping the username/password dev qt/qtbase Status: MERGED +2 0
          651670,2 SQL/ODBC: fix escaping the username/password 6.10 qt/qtbase Status: MERGED +2 0
          651770,2 SQL/ODBC: fix escaping the username/password 6.9 qt/qtbase Status: MERGED +2 0
          651885,2 SQL/ODBC: fix escaping the username/password tqtc/lts-6.8 qt/tqtc-qtbase Status: MERGED +2 0

          Activity

            People

              chehrlic Christian Ehrlicher
              mahdi.belila Mehdi Belila
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: