Problem with DB connection [SOLVED]

[lzr_mihnea]

I've been trying to connect my program to a database, unsuccessful
@#include <QCoreApplication>
#include <QtSql>
#include <QtDebug>

int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);

// QString servername = "LOCALHOST\SQLEXPRESS";
QString servername = "LOCALHOST\MYSQL";
QString dbname = "test.dat";

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");

db.setConnectOptions();

QString dsn = QString("DRIVER=(SQL Native Client);SERVER=%1;DATABASE=%2;UID=root;PWD=root;").arg(servername).arg(dbname);

// QString dsn = QString("DRIVER=(SQL Native Client);SERVER=%1;DATABASE=%2;Trusted_Connection=Yes;").arg(servername).arg(dbname);

// db.setDatabaseName(":memory:");
db.setDatabaseName(dsn);

if(db.open())
{
    qDebug() << "Opened!";
    db.close();
} else {
    qDebug() << "Error: " << db.lastError().text() ;
}


return a.exec(&#41;;

}
@

The error I keep getting is "out of memory Error opening database".
I use UniServer, with Apache and MySQL.

If anyone has any ideas, I'd be grateful.

Regards!

[[merged two identical posts, Tobias]]

[mbnoimi]

You don't need to use DSN and you've to use addDatabase("QMYSQL"); .... try to read this post:
https://qt-project.org/forums/viewthread/12380

[lzr_mihnea]

It worked!
Thank you very much!

[mbnoimi]

Could you please tag this thread as [SOLVED]

[lzr_mihnea]

the tag was added by someone, I also updated the title.
Regards!