Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Postgresql driver is not found
Forum Updated to NodeBB v4.3 + New Features

Postgresql driver is not found

Scheduled Pinned Locked Moved Unsolved General and Desktop
35 Posts 5 Posters 4.5k Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A alxdef

    Re: POSTGRES QPSQL not loading

    Hello!
    I have old problem with new soft. Got a message "Cannot load library C:\Qt\5.15.2\mingw81_64\plugins\sqldrivers\qsqlpsql.dll"
    on Win 10 Pro x64 and Postgresql 13 x64. The path is valid.
    I've smoked all web sources about this problem, used all advices but nothing changed. Is there any solution?

    JonBJ Offline
    JonBJ Offline
    JonB
    wrote on last edited by
    #2

    @alxdef
    Start with checking with a suitable Dependency Walker. Otherwise what didn't work in the proposals in the thread you reference?

    A 1 Reply Last reply
    0
    • JonBJ JonB

      @alxdef
      Start with checking with a suitable Dependency Walker. Otherwise what didn't work in the proposals in the thread you reference?

      A Offline
      A Offline
      alxdef
      wrote on last edited by
      #3

      @JonB

      Here DW output:
      523d9a1d-5b18-4de3-a968-ce6003d55478-изображение.png
      But DW fault with this:
      f01e8bb5-f5ae-46e2-877c-35214a135f8b-изображение.png

      1. I tried to add paths to Postgres "bin" and "lib" folders - no way.
      2. Copy DLLs to different folders: "build", "plugins\build" and other variations - no luck.
      3. I didn't build database libraries myself.
      Christian EhrlicherC 1 Reply Last reply
      0
      • SGaistS Offline
        SGaistS Offline
        SGaist
        Lifetime Qt Champion
        wrote on last edited by
        #4

        Hi and welcome to devnet,

        On Qt Creator, add the QT_DEBUG_PLUGINS environment variable set to 1 in the Run part of the project panel. You'll have more information about what is going wrong.

        Interested in AI ? www.idiap.ch
        Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

        A 1 Reply Last reply
        1
        • SGaistS SGaist

          Hi and welcome to devnet,

          On Qt Creator, add the QT_DEBUG_PLUGINS environment variable set to 1 in the Run part of the project panel. You'll have more information about what is going wrong.

          A Offline
          A Offline
          alxdef
          wrote on last edited by
          #5

          @SGaist
          Hi there!
          I've already done this. The message I got is directly from application output.

          1 Reply Last reply
          0
          • SGaistS Offline
            SGaistS Offline
            SGaist
            Lifetime Qt Champion
            wrote on last edited by
            #6

            In the list of plugins information dumped in your application, you should have why the plugin failed to load. You did not show that in what you posted.

            Interested in AI ? www.idiap.ch
            Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

            A 1 Reply Last reply
            0
            • SGaistS SGaist

              In the list of plugins information dumped in your application, you should have why the plugin failed to load. You did not show that in what you posted.

              A Offline
              A Offline
              alxdef
              wrote on last edited by
              #7

              @SGaist
              Here the supplement message to my first one: "QLibraryPrivate::loadPlugin failed on "C:/Qt/5.15.2/mingw81_64/plugins/sqldrivers/qsqlpsql.dll""

              1 Reply Last reply
              0
              • SGaistS Offline
                SGaistS Offline
                SGaist
                Lifetime Qt Champion
                wrote on last edited by
                #8

                Can you should the complete output of your application ?

                Interested in AI ? www.idiap.ch
                Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                A 1 Reply Last reply
                0
                • SGaistS SGaist

                  Can you should the complete output of your application ?

                  A Offline
                  A Offline
                  alxdef
                  wrote on last edited by
                  #9

                  @SGaist
                  Here the part of application output about DLL load failure:

                  Got keys from plugin meta data ("QPSQL7", "QPSQL")
                  QFactoryLoader :: QFactoryLoader () checking directory path "…/ build-MCS-Desktop_Qt_5_15_2_MinGW_64_bit-Debug / Shell / debug / sqldrivers" …
                  Cannot load library C: \ Qt \ 5.15.2 \ mingw81_64 \ plugins \ sqldrivers \ qsqlpsql.dll: The specified module could not be found.
                  QLibraryPrivate :: loadPlugin failed on "C:/Qt/5.15.2/mingw81_64/plugins/sqldrivers/qsqlpsql.dll": "Cannot load library C: \\ Qt \\ 5.15.2 \\ mingw81_64 \\ plugins \\ sqldrivers \\ qsqlpsql.dll: The specified module could not be found. "
                  QSqlDatabase: QPSQL driver not loaded
                  QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7
                  

                  Tell me what additional information is needed?

                  1 Reply Last reply
                  0
                  • SGaistS Offline
                    SGaistS Offline
                    SGaist
                    Lifetime Qt Champion
                    wrote on last edited by
                    #10

                    Just remembered something, check that you have also copied the dependencies of the PostgreSQL .dll.

                    Interested in AI ? www.idiap.ch
                    Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                    A 1 Reply Last reply
                    0
                    • SGaistS SGaist

                      Just remembered something, check that you have also copied the dependencies of the PostgreSQL .dll.

                      A Offline
                      A Offline
                      alxdef
                      wrote on last edited by
                      #11

                      @SGaist
                      Am I on the right way? Which of them should be added in project executable folder?
                      0a0a354b-bca6-4f8a-9853-925170780b62-изображение.png

                      1 Reply Last reply
                      0
                      • SGaistS Offline
                        SGaistS Offline
                        SGaist
                        Lifetime Qt Champion
                        wrote on last edited by
                        #12

                        The OpenSSL related

                        Interested in AI ? www.idiap.ch
                        Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                        A 1 Reply Last reply
                        0
                        • SGaistS SGaist

                          The OpenSSL related

                          A Offline
                          A Offline
                          alxdef
                          wrote on last edited by
                          #13

                          @SGaist said in Postgresql driver is not found:

                          The OpenSSL related

                          Not works.

                          1 Reply Last reply
                          0
                          • SGaistS Offline
                            SGaistS Offline
                            SGaist
                            Lifetime Qt Champion
                            wrote on last edited by
                            #14

                            Then run Dependency Walker on these.
                            The next likely candidate is the VC runtime dll.

                            Interested in AI ? www.idiap.ch
                            Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                            A 1 Reply Last reply
                            0
                            • SGaistS SGaist

                              Then run Dependency Walker on these.
                              The next likely candidate is the VC runtime dll.

                              A Offline
                              A Offline
                              alxdef
                              wrote on last edited by
                              #15

                              @SGaist
                              8312aaa0-8559-414d-af11-2e88661267da-изображение.png
                              I think that library is not in business.

                              1 Reply Last reply
                              0
                              • SGaistS Offline
                                SGaistS Offline
                                SGaist
                                Lifetime Qt Champion
                                wrote on last edited by
                                #16

                                I meant that you should run Dependency Walker on the OpenSSL dlls and that it would have likely been the VC runtime missing.

                                Interested in AI ? www.idiap.ch
                                Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                                A 1 Reply Last reply
                                0
                                • SGaistS SGaist

                                  I meant that you should run Dependency Walker on the OpenSSL dlls and that it would have likely been the VC runtime missing.

                                  A Offline
                                  A Offline
                                  alxdef
                                  wrote on last edited by
                                  #17

                                  @SGaist

                                  1c6655d5-a634-4197-bd37-83ae354f1564-изображение.png

                                  It looks like infinite loop…

                                  1 Reply Last reply
                                  0
                                  • SGaistS Offline
                                    SGaistS Offline
                                    SGaist
                                    Lifetime Qt Champion
                                    wrote on last edited by SGaist
                                    #18

                                    Did you copy the VC runtime in the same folder as the OpenSSL library ?

                                    Interested in AI ? www.idiap.ch
                                    Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                                    1 Reply Last reply
                                    0
                                    • A alxdef

                                      @JonB

                                      Here DW output:
                                      523d9a1d-5b18-4de3-a968-ce6003d55478-изображение.png
                                      But DW fault with this:
                                      f01e8bb5-f5ae-46e2-877c-35214a135f8b-изображение.png

                                      1. I tried to add paths to Postgres "bin" and "lib" folders - no way.
                                      2. Copy DLLs to different folders: "build", "plugins\build" and other variations - no luck.
                                      3. I didn't build database libraries myself.
                                      Christian EhrlicherC Online
                                      Christian EhrlicherC Online
                                      Christian Ehrlicher
                                      Lifetime Qt Champion
                                      wrote on last edited by
                                      #19

                                      @alxdef Your first screenshot tells you that libstdc++-6.dll is missing.

                                      Qt Online Installer direct download: https://download.qt.io/official_releases/online_installers/
                                      Visit the Qt Academy at https://academy.qt.io/catalog

                                      SGaistS A 2 Replies Last reply
                                      1
                                      • Christian EhrlicherC Christian Ehrlicher

                                        @alxdef Your first screenshot tells you that libstdc++-6.dll is missing.

                                        SGaistS Offline
                                        SGaistS Offline
                                        SGaist
                                        Lifetime Qt Champion
                                        wrote on last edited by
                                        #20

                                        @Christian-Ehrlicher said in Postgresql driver is not found:

                                        @alxdef Your first screenshot tells you that libstdc++-6.dll is missing.

                                        Arf ! I missed that one. Good catch :-)

                                        Interested in AI ? www.idiap.ch
                                        Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                                        1 Reply Last reply
                                        0
                                        • Christian EhrlicherC Christian Ehrlicher

                                          @alxdef Your first screenshot tells you that libstdc++-6.dll is missing.

                                          A Offline
                                          A Offline
                                          alxdef
                                          wrote on last edited by
                                          #21

                                          @Christian-Ehrlicher

                                          These libs are present in my app executable folder:

                                          sqldrivers\qsqlpsql.dll
                                          platforms\qwindows.dll
                                          vcruntime140.dll
                                          Qt5Sql.dll
                                          Qt5Core.dll
                                          msvcrt.dll
                                          libstdc++-6.dll
                                          libssl-1_1-x64.dll
                                          libpq.dll
                                          libintl-8.dll
                                          libcrypto-1_1-x64.dll
                                          
                                          1 Reply Last reply
                                          0

                                          • Login

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • Users
                                          • Groups
                                          • Search
                                          • Get Qt Extensions
                                          • Unsolved