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 Offline
    A Offline
    alxdef
    wrote on 23 Nov 2020, 18:07 last edited by
    #1

    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?

    J 1 Reply Last reply 23 Nov 2020, 18:11
    0
    • A alxdef
      23 Nov 2020, 18:07

      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?

      J Online
      J Online
      JonB
      wrote on 23 Nov 2020, 18:11 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 23 Nov 2020, 18:59
      0
      • J JonB
        23 Nov 2020, 18:11

        @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 23 Nov 2020, 18:59 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.
        C 1 Reply Last reply 25 Nov 2020, 19:16
        0
        • S Offline
          S Offline
          SGaist
          Lifetime Qt Champion
          wrote on 23 Nov 2020, 19:01 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 23 Nov 2020, 19:11
          1
          • S SGaist
            23 Nov 2020, 19:01

            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 23 Nov 2020, 19:11 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
            • S Offline
              S Offline
              SGaist
              Lifetime Qt Champion
              wrote on 23 Nov 2020, 19:16 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 23 Nov 2020, 19:22
              0
              • S SGaist
                23 Nov 2020, 19:16

                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 23 Nov 2020, 19:22 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
                • S Offline
                  S Offline
                  SGaist
                  Lifetime Qt Champion
                  wrote on 23 Nov 2020, 19:23 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 23 Nov 2020, 19:36
                  0
                  • S SGaist
                    23 Nov 2020, 19:23

                    Can you should the complete output of your application ?

                    A Offline
                    A Offline
                    alxdef
                    wrote on 23 Nov 2020, 19:36 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
                    • S Offline
                      S Offline
                      SGaist
                      Lifetime Qt Champion
                      wrote on 23 Nov 2020, 19:51 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 24 Nov 2020, 05:19
                      0
                      • S SGaist
                        23 Nov 2020, 19:51

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

                        A Offline
                        A Offline
                        alxdef
                        wrote on 24 Nov 2020, 05:19 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
                        • S Offline
                          S Offline
                          SGaist
                          Lifetime Qt Champion
                          wrote on 24 Nov 2020, 19:23 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 25 Nov 2020, 17:21
                          0
                          • S SGaist
                            24 Nov 2020, 19:23

                            The OpenSSL related

                            A Offline
                            A Offline
                            alxdef
                            wrote on 25 Nov 2020, 17:21 last edited by
                            #13

                            @SGaist said in Postgresql driver is not found:

                            The OpenSSL related

                            Not works.

                            1 Reply Last reply
                            0
                            • S Offline
                              S Offline
                              SGaist
                              Lifetime Qt Champion
                              wrote on 25 Nov 2020, 17:23 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 25 Nov 2020, 18:34
                              0
                              • S SGaist
                                25 Nov 2020, 17:23

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

                                A Offline
                                A Offline
                                alxdef
                                wrote on 25 Nov 2020, 18:34 last edited by
                                #15

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

                                1 Reply Last reply
                                0
                                • S Offline
                                  S Offline
                                  SGaist
                                  Lifetime Qt Champion
                                  wrote on 25 Nov 2020, 18:45 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 25 Nov 2020, 19:13
                                  0
                                  • S SGaist
                                    25 Nov 2020, 18:45

                                    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 25 Nov 2020, 19:13 last edited by
                                    #17

                                    @SGaist

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

                                    It looks like infinite loop…

                                    1 Reply Last reply
                                    0
                                    • S Offline
                                      S Offline
                                      SGaist
                                      Lifetime Qt Champion
                                      wrote on 25 Nov 2020, 19:16 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
                                        23 Nov 2020, 18:59

                                        @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.
                                        C Offline
                                        C Offline
                                        Christian Ehrlicher
                                        Lifetime Qt Champion
                                        wrote on 25 Nov 2020, 19:16 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

                                        S A 2 Replies Last reply 25 Nov 2020, 19:25
                                        1
                                        • C Christian Ehrlicher
                                          25 Nov 2020, 19:16

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

                                          S Offline
                                          S Offline
                                          SGaist
                                          Lifetime Qt Champion
                                          wrote on 25 Nov 2020, 19:25 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

                                          1/35

                                          23 Nov 2020, 18:07

                                          • Login

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