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. Opening the database

Opening the database

Scheduled Pinned Locked Moved General and Desktop
1 Posts 1 Posters 626 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.
  • M Offline
    M Offline
    MichaelStein
    wrote on last edited by
    #1

    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
    0

    • Login

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