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. Files needed for mysql for client devices
Forum Updated to NodeBB v4.3 + New Features

Files needed for mysql for client devices

Scheduled Pinned Locked Moved Unsolved General and Desktop
9 Posts 4 Posters 284 Views 2 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.
  • T Offline
    T Offline
    Thank You
    wrote on 1 Jun 2021, 03:56 last edited by Thank You 6 Jan 2021, 06:12
    #1

    I have succesfully configured database from cpanel and everything is working fine in development machine(my machine). I send it to client and Got the error that driver is not loaded.
    I used this link to configure mysql database
    https://github.com/thecodemonkey86/qt_mysql_driver/releases/tag/qmysql_5.12.8
    What should I do to make it work??
    Should I copy files there If so Which files should I copy
    I had copied 5 files to c:/windows
    6b972de0-896b-4510-9427-ef7a21c6079c-image.png

    I can't frequently request client to test it So can you guys ( @JonB @jsulm @mrjj @Christian-Ehrlicher ) help?

    Let's make QT free or It will go forever

    TRUE AND FALSE <3

    J 1 Reply Last reply 1 Jun 2021, 06:25
    0
    • T Thank You
      1 Jun 2021, 03:56

      I have succesfully configured database from cpanel and everything is working fine in development machine(my machine). I send it to client and Got the error that driver is not loaded.
      I used this link to configure mysql database
      https://github.com/thecodemonkey86/qt_mysql_driver/releases/tag/qmysql_5.12.8
      What should I do to make it work??
      Should I copy files there If so Which files should I copy
      I had copied 5 files to c:/windows
      6b972de0-896b-4510-9427-ef7a21c6079c-image.png

      I can't frequently request client to test it So can you guys ( @JonB @jsulm @mrjj @Christian-Ehrlicher ) help?

      J Offline
      J Offline
      jsulm
      Lifetime Qt Champion
      wrote on 1 Jun 2021, 06:25 last edited by
      #2

      @Thank-You said in Files needed for mysql for client devices:

      Should I copy files there If so Which files should I copy

      You need to copy mysqlclient.dll (not lib!) file together with your app. You can use https://www.dependencywalker.com/ tool to check what is needed.
      To test locally you could use a virtual machine with Windows without any Qt and MySQL stuff installed.

      https://forum.qt.io/topic/113070/qt-code-of-conduct

      T 1 Reply Last reply 3 Jun 2021, 05:26
      3
      • J jsulm
        1 Jun 2021, 06:25

        @Thank-You said in Files needed for mysql for client devices:

        Should I copy files there If so Which files should I copy

        You need to copy mysqlclient.dll (not lib!) file together with your app. You can use https://www.dependencywalker.com/ tool to check what is needed.
        To test locally you could use a virtual machine with Windows without any Qt and MySQL stuff installed.

        T Offline
        T Offline
        Thank You
        wrote on 3 Jun 2021, 05:26 last edited by
        #3

        @jsulm My computer doesn't support virtual machine so I tried to search mysqlclient.dll But could not found in the whole machine

        dir mysqlclient.dll /s

        Should I install connector in client machine ?

        Let's make QT free or It will go forever

        TRUE AND FALSE <3

        1 Reply Last reply
        0
        • S Offline
          S Offline
          SGaist
          Lifetime Qt Champion
          wrote on 3 Jun 2021, 06:13 last edited by
          #4

          Hi,

          Do not copy files in C:/Windows. It's a really bad habit that some applications developers used rather than properly deploy their application.

          .lib files won't help you as they are only use to compile your application. You need to deploy the connector dll along your application.

          If your application runs successfully on your development machine, it means that you have all .dlls at hand. As suggested by @jsulm, use something like Dependency Walker to find out where the plugin gets its dependencies.

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

          T 1 Reply Last reply 3 Jun 2021, 09:49
          2
          • S SGaist
            3 Jun 2021, 06:13

            Hi,

            Do not copy files in C:/Windows. It's a really bad habit that some applications developers used rather than properly deploy their application.

            .lib files won't help you as they are only use to compile your application. You need to deploy the connector dll along your application.

            If your application runs successfully on your development machine, it means that you have all .dlls at hand. As suggested by @jsulm, use something like Dependency Walker to find out where the plugin gets its dependencies.

            T Offline
            T Offline
            Thank You
            wrote on 3 Jun 2021, 09:49 last edited by
            #5

            @SGaist
            7b831b59-a7e6-42cb-b140-9f7f875ed443-image.png

            Everything is working as excepted except connection to database(mysql)
            But there is not such thing that you said ?

            Let's make QT free or It will go forever

            TRUE AND FALSE <3

            J 1 Reply Last reply 3 Jun 2021, 10:05
            0
            • T Thank You
              3 Jun 2021, 09:49

              @SGaist
              7b831b59-a7e6-42cb-b140-9f7f875ed443-image.png

              Everything is working as excepted except connection to database(mysql)
              But there is not such thing that you said ?

              J Offline
              J Offline
              JonB
              wrote on 3 Jun 2021, 10:05 last edited by JonB 6 Mar 2021, 10:05
              #6

              @Thank-You
              I believe that the fact that items with 64 are marked in red indicates that it is picking up 64-bit DLLs as dependencies of 32-bit DLLs, which won't work. But I stand to be corrected on this.

              Somewhere else (top or bottom) of that view in Dependency Walker, does it not give you a warning about mixing 32- & 64-bit DLLs?

              1 Reply Last reply
              0
              • S Offline
                S Offline
                SGaist
                Lifetime Qt Champion
                wrote on 3 Jun 2021, 11:16 last edited by
                #7

                You are checking the QtSql library. What you need to check is the MySQL plugin.

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

                T 1 Reply Last reply 3 Jun 2021, 11:30
                1
                • S SGaist
                  3 Jun 2021, 11:16

                  You are checking the QtSql library. What you need to check is the MySQL plugin.

                  T Offline
                  T Offline
                  Thank You
                  wrote on 3 Jun 2021, 11:30 last edited by
                  #8

                  @SGaist These are only the lists.
                  The only which has sql keyword is this list.
                  I have just minimized(closed) other things.

                  Let's make QT free or It will go forever

                  TRUE AND FALSE <3

                  1 Reply Last reply
                  0
                  • S Offline
                    S Offline
                    SGaist
                    Lifetime Qt Champion
                    wrote on 3 Jun 2021, 11:42 last edited by
                    #9

                    You need to go into the plugins folder.

                    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/9

                    1 Jun 2021, 03:56

                    • Login

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