Opening the database

MichaelStein

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