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!