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 289 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.
  • Thank YouT Offline
    Thank YouT Offline
    Thank You
    wrote on last edited by Thank You
    #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

    jsulmJ 1 Reply Last reply
    0
    • Thank YouT Thank You

      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?

      jsulmJ Offline
      jsulmJ Offline
      jsulm
      Lifetime Qt Champion
      wrote on 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

      Thank YouT 1 Reply Last reply
      3
      • jsulmJ jsulm

        @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.

        Thank YouT Offline
        Thank YouT Offline
        Thank You
        wrote on 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
        • SGaistS Offline
          SGaistS Offline
          SGaist
          Lifetime Qt Champion
          wrote on 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

          Thank YouT 1 Reply Last reply
          2
          • SGaistS SGaist

            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.

            Thank YouT Offline
            Thank YouT Offline
            Thank You
            wrote on 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

            JonBJ 1 Reply Last reply
            0
            • Thank YouT Thank You

              @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 ?

              JonBJ Offline
              JonBJ Offline
              JonB
              wrote on last edited by JonB
              #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
              • SGaistS Offline
                SGaistS Offline
                SGaist
                Lifetime Qt Champion
                wrote on 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

                Thank YouT 1 Reply Last reply
                1
                • SGaistS SGaist

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

                  Thank YouT Offline
                  Thank YouT Offline
                  Thank You
                  wrote on 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
                  • SGaistS Offline
                    SGaistS Offline
                    SGaist
                    Lifetime Qt Champion
                    wrote on 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

                    • Login

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