Connect To sqlServer Database Problem

[M4RZB4Ni]

Hello,
i Want To Connect To a database from SQL SERVER and I Wrote This Codes But
Dose Not Worked!

anybody can Help me Please?
Codes:

#include "mainwindow.h"
#include "ui_mainwindow.h"
#include <QSql>
#include <QSqlDatabase>
#include <QMessageBox>

MainWindow::MainWindow(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::MainWindow)
{
    ui->setupUi(this);
    QString serverNam="localhost\\QSQLSERVER";
    QString dbname="msdb";
    QSqlDatabase db=QSqlDatabase::addDatabase("QODBC");
db.setConnectOptions();
QString dsn=QString("DRIVER={SQL Server};Server=%1;DATABASE=%2,Trusted_Connection=Yes;").arg(serverNam).arg(dbname);

db.setDatabaseName(dsn);

    if(!db.open())
    {
        QMessageBox *sts=new QMessageBox;
        sts->setText("faild!");
        sts->exec();
    }

}

MainWindow::~MainWindow()
{
    delete ui;
}

Sql Server Screenshot
Note:
I added

QT       += sql

code in my .Pro File

Thanks.

[SGaist]

Hi,

Might be a silly question but, are you sure you have the driver QODBC availalbe.

[M4RZB4Ni]

@SGaist
silly is someone who is Rude Not SomeOne dont Khow!

[Vicky Sharma]

@SGaist
what you error caught during execution?

[M4RZB4Ni]

@Vicky-Sharma
Just Show my Message in IF CONDITION that show "fail"!
and my ODBC Drivers Already Installed.

[SGaist]

Rather than fail you should print the content of QSqlDatabase::lastError.

[M4RZB4Ni]

@SGaist
@Vicky-Sharma
Thanks
this is my Error
http://8pic.ir/images/kab0zjxk7ytw9yao2rxe.png
What i must do Exactly ?

[SGaist]

As silly as it may sound, fix the problem described by the message. Either your server is not accessible e.g. doesn't run or you can't access it because of missing credentials.

[hskoglund]

Hi, also to add to @SGaist, don't use Named Pipes for the connection (they're kind of ancient) instead you could try something simple like:
QString dsn="DRIVER=SQL Server;Server=127.0.0.1; Database=Test;Trusted_Connection=Yes";

[M4RZB4Ni]

@hskoglund
Thanks
i Replaced that ip But Showed Me This Message
ERROR
Sql Server

[hskoglund]

Aha, ok, then instead try specify your name and password:
QString dsn="DRIVER=SQL Server;Server=LocalHost;Database=Test;uid=Doctor Corpartion;pwd=MyPassword";

note: also I changed from 127.0.0.1 to LocalHost (it's the same)

EDIT: forgot to say: also try with username/password for your SQL Server, usually the username is sa

[M4RZB4Ni]

@hskoglund
Thank You So much man
My Problem Solved!