Qt Forum

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Unsolved

    Qt + Mysql Embedded, compiles fine but crashes (exit code 1) on db.open() call

    General and Desktop
    4
    6
    3899
    Loading More Posts
    • 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.
    • G
      galrub last edited by

      Hello all,

      I'm trying to work with mysql Embedded drive on qt using VS2010.. everything compiles well, and the dll seem to lead fine, here is the output:

      @
      'QTMysqlTest.exe': Loaded 'C:\Deve\CPP\QTDBLayer\QTMysqlTest.exe', Symbols loaded.
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\ntdll.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\kernel32.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\KernelBase.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'D:\Deve\QT\qt4.7.1\bin\QtCored4.dll', Symbols loaded.
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\user32.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\gdi32.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\lpk.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\usp10.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\msvcrt.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\advapi32.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\sechost.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\rpcrt4.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\sspicli.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\cryptbase.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\ole32.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\ws2_32.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\nsi.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Deve\QT\qt4.7.1\bin\QtSqld4.dll', Symbols loaded.
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\imm32.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\msctf.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\winmm.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'D:\Deve\QT\qt4.7.1\plugins\sqldrivers\qsqlmysqld4.dll', Symbols loaded.
      'QTMysqlTest.exe': Loaded 'C:\mysql-5.1.30-win32\Embedded\DLL\debug\libmysqld.dll', Symbols loaded. //notice it's loading this dll, no path issue
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\wsock32.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\nlaapi.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\mswsock.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\dnsapi.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\winrnr.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\NapiNSP.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\pnrpnsp.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\wshbth.dll', Cannot find or open the PDB file
      'QTMysqlTest.exe': Loaded 'C:\Windows\SysWOW64\rasadhlp.dll', Cannot find or open the PDB file
      The thread 'Win32 Thread' (0x1688) has exited with code 1 (0x1).
      The thread 'Win32 Thread' (0x154c) has exited with code 1 (0x1).
      The thread 'Win32 Thread' (0x1524) has exited with code 1 (0x1).
      The thread 'Win32 Thread' (0x1230) has exited with code 1 (0x1).
      The thread 'Win32 Thread' (0x16e8) has exited with code 1 (0x1).
      The program '[5484] QTMysqlTest.exe: Native' has exited with code 1 (0x1).
      @

      here is the code:
      @
      #include <QtCore/QCoreApplication>
      #include <QtSql>
      #include <QtDebug>

      int main(int argc, char *argv[])
      {
      QCoreApplication a(argc, argv);
      QString connectionName = "DbThread-" + QDateTime::currentDateTime().toString("yyyyMMddhhmmsszzz");
      QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL", connectionName);
      db.setHostName("localhost");
      db.setDatabaseName("mysql");
      db.setUserName("root");
      db.setPassword("root");
      bool gotOk = false;
      gotOk = db.open(); //crashes here
      if( gotOk )
      {
      qDebug() << db.lastError();
      qFatal( "Failed to connect." );
      }
      else
      {
      qDebug() << db.connectionName();
      }

      db.close();
      return 0;
      }
      @
      sqlite works fine, BTW, so I'm not sure that the windows 7 64bit has any effect here.
      also, note that I'm using both in the test and in the qt libraries with Runtime Libraries flag /MTd and not /MDd so it might be there.

      any ideas?
      Thanks

      1 Reply Last reply Reply Quote 0
      • G
        galrub last edited by

        I have the same problem, where u able to find a solution?

        Thanks

        1 Reply Last reply Reply Quote 0
        • L
          lgeyer last edited by

          Well, it's getting late but is it possible that you are the OP of this thread?

          1 Reply Last reply Reply Quote 0
          • G
            galrub last edited by

            OMG! u are right, I feel so stupid, sorry.

            I wrote a new thread with a more up to date status, it was moved by the moderator to "this place":http://developer.qt.nokia.com/forums/viewthread/10027/

            1 Reply Last reply Reply Quote 0
            • A
              ApsarF last edited by

              Hi i m new into .Net environment I'm facing this issue when I m trying to build an desktop application.

              Error 2 The command ""C:\Program Files (x86)\Microsoft\ILMerge\ilmerge.exe" /target:winexe /out:E:\DotNet\blu - Bulk Lead Upload -Apsar\2012-08-30.01-d-vs-pc-dg-all\BulkLeadUpload\BulkLeadUpload\bin\Release........\publish\BulkLeadUploadSingleV1.0.exe E:\DotNet\blu - Bulk Lead Upload -Apsar\2012-08-30.01-d-vs-pc-dg-all\BulkLeadUpload\BulkLeadUpload\bin\Release\BulkLeadUpload.exe E:\DotNet\blu - Bulk Lead Upload -Apsar\2012-08-30.01-d-vs-pc-dg-all\BulkLeadUpload\BulkLeadUpload\bin\Release....\dll\MySql.Data.dll" exited with code 1. BulkLeadUpload

              1 Reply Last reply Reply Quote 0
              • SGaist
                SGaist Lifetime Qt Champion last edited by

                Hi and welcome to devnet,

                What does it have to do with Qt ?

                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 Reply Quote 0
                • First post
                  Last post