Qt Forum

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

    Update: Forum Guidelines & Code of Conduct

    Opening the database

    General and Desktop
    1
    1
    489
    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.
    • M
      MichaelStein last edited by

      Hi everyone,

      I have been having trouble open my database. Here is my code:
      In the .pro file
      @QT += sql@

      In the .cpp file:

      @#include <QtSql/QSqlDatabase>

      QSqlDatabase ods = QSqlDatabase::addDatabase("QODBC");

      ods.setDatabaseName("DRIVER={LibreOffice Driver (*.ods)};DBQ=" + QString("C:\Qt\2010.04\qt\Example2\yarzsample.ods") );
      
      if (ods.open())
      {
          
          qDebug() << "Opened successfully!";
      
      }
      else
      {
          qDebug() << "Error";
          QMessageBox::critical(0, QObject::tr("Database Error"), "Failed to open");
          return;
      }@
      

      Everytime I run the program, the Error message box appear with "Failed to open file". So obviously, ods.open() is not working. I wonder why?
      The truth is, all I am trying to do is be able to load names a dates from a .ods file (LibreOffice Calc). Can anyone offer advice?
      Thanks

      1 Reply Last reply Reply Quote 0
      • First post
        Last post