[SOLVED] Connect to SQL using Qt

L471

Hey,

I've been searching around a fair amount for a solution and been trying for the last week to get my connection to SQL working but I seems to be banging my head against the wall, which probably means my mistake is a simple set up one that I'm overlooking.

So any help anyone can give me would be much appreciated.

SS from SQL manager - http://imgur.com/c3NZq2H
Server LancesPC\SQLEXPRESS

SS from ODBC Connections in control panel
http://imgur.com/cdH4JlR (apparently I had to set up the driver as SQL Server.

My Qt code.

@#include <QCoreApplication>
#include <QtSql>
#include <QtDebug>

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

QString servername = "LANCESPC\\SQLEXPRESS";
QString dbname = "TEST1";
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setConnectOptions();
QString dsn = QString("DRIVER=(SQL Server);SERVER=%1;DATABASE=%2;Trusted_Connection=Yes;").arg(servername).arg(dbname);

db.setDatabaseName(dsn);

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


return a.exec(&#41;;

}
@

And most importantly, the error message
http://imgur.com/kslXQdr

Any help in pointing out where I have gone wrong would be really appreciated.

Thanks,

Lance

Chris Kawa

I'm not a db expert, so I don't know if that matters, but shouldn't it be
@
QString dsn = QString("DRIVER={SQL Server};SERVER=%1;DATABASE=%2;Trusted_Connection=Yes;")
.arg(servername, dbname);@
i.e. {} instead of () ?

hskoglund

Hi, actually you can get by even easier:
@
QString dsn = QString("Driver=SQL Server; Server=%1; Database=%2;Trusted_Connection=Yes;").arg(servername, dbname);
@

Haven't tried SQL Express recently, I use vanilla SQL Server, but Qt should work the same. (If you want to look at my DSN fiddling etc. my opensource healthcare .cpp file is here "CWDB.cpp":https://github.com/Clinware/CWDB/blob/master/CWDB.cpp )

EDIT: forgot about your error message: "data source name not found"
I get the same error often when I try using a name for the server, better is to use the ip number, like "127.0.0.1" if SQL Express is running on the same PC as your Qt. Also make sure it's listening on port 1433, if not you'll have to call "setPort":http://qt-project.org/doc/qt-5/qsqldatabase.html#setPort

L471

Thanks for the help Chris that seemed to work :)

@Hskoglund - I'll give it a go. Hopefully that should make the code a bit better.