Qsql and connection

[smemamian]

hi
I do not understand line 7 and 11,Please explain

#include <QCoreApplication>
#include <QtSql>
 
int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);
    QString servername = "LOCALHOST\\SQLEXPRESS" ;
    QString dbname = "test";
    QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
    db.setConnectOptions();
    QString dsn = QString("DRIVER={SQL Native Client);SERVER=%1;DATABASE=%2;Trusted_Connection=Yes;").arg(servername).arg(dbname);
    db.setDatabaseName(dsn);
 
    return a.exec();
}

#include <QCoreApplication>
#include <QtSql>

int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);
    QString servername = "LOCALHOST\\SQLEXPRESS" ;
    QString dbname = "test";
    QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
    db.setConnectOptions();
    QString dsn = QString("DRIVER={SQL Native Client);SERVER=%1;DATABASE=%2;Trusted_Connection=Yes;").arg(servername).arg(dbname);
    db.setDatabaseName(dsn);
    
    return a.exec();
}

To copy to clipboard, switch view to plain text mode 

tnx

[alizadeh91]

Simply you are filling properties of db. servername is address or name of your server. because your computer is your own server so you have to use LOCALHOST or 127.0.0.1 for server name.

[ChrisW67]

The string you are constructing at Line 11 is a Data Source Name (DSN) which encapsulates a bunch of settings that you could, alternatively, set up in the Windows ODBC Manager. You should have a driver named "SQL Native Client" in the ODBC Manager.

Also, the line should read:

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

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

To copy to clipboard, switch view to plain text mode 

Note a ')' became a '}'

[smemamian]

thanks a lot .

Why do I get the error message when I compile ?

QsqlDatabase: QODBC driver not loaded
QSqlDataase : available drivers:QSQLITE

my code :

#include <QCoreApplication>
#include <QtSql>
#include <QDebug>
int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);
    QString servername = "LOCALHOST\\SQLEXPRESS" ;
    QString dbname = "test";
    QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
    db.setConnectOptions();
    QString dsn = QString("DRIVER={SQL Native Client};SERVER=%1;DATABASE=%2;Trusted_Connection=Yes;").arg(servername).arg(dbname);
    db.setDatabaseName(dsn);
 
    if(db.open())
    {
        qDebug() << "Opene.." ;
    }
 
    else
        qDebug() << "Not Opene.." << db.lastError();
 
    return a.exec();
}

#include <QCoreApplication>
#include <QtSql>
#include <QDebug>
int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);
    QString servername = "LOCALHOST\\SQLEXPRESS" ;
    QString dbname = "test";
    QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
    db.setConnectOptions();
    QString dsn = QString("DRIVER={SQL Native Client};SERVER=%1;DATABASE=%2;Trusted_Connection=Yes;").arg(servername).arg(dbname);
    db.setDatabaseName(dsn);

    if(db.open())
    {
        qDebug() << "Opene.." ;
    }

    else
        qDebug() << "Not Opene.." << db.lastError();
    
    return a.exec();
}

To copy to clipboard, switch view to plain text mode 

Microsoft SQL Server 2008
Windows 7

[alizadeh91]

It seems that you have not built QODBC driver. You have to build it first (find its source in Src\qtbase\src\plugins\sqldrivers)

---

Added after 6 minutes:

See this :

http://qt-project.org/doc/qt-4.8/sql...gin-on-windows

for how to build odbc plugin on windows

[smemamian]

i open cmd and i write :

cd C:\Qt\Qt5.0.0\5.0.0\Src\qtbase\src\plugins\sqldrivers\odbc
qmake odbc.pro

cd C:\Qt\Qt5.0.0\5.0.0\Src\qtbase\src\plugins\sqldrivers\odbc
qmake odbc.pro

To copy to clipboard, switch view to plain text mode 

I get the error message :

'qmake' is not recognized as a internal or external command ,
operable program of batch file

[alizadeh91]

Did u add qmake to your environment variables???

[smemamian]

no, how ?

[alizadeh91]

1.RightClick on mycomputer
2. click properties
3. go to "change settings" in the link at bottom right corner of window
4. go to "advance" tab
5. Press environment variables
6. from system variables list, double click on "path"
7. First of all put a ";" at end of "variable value" then paste address of your qmake (e.g C:\Qt\Qt5.0.0\5.0.0\msvc2010\bin) out there after the simicolon (";")
8. reopen the cmd then type "qmake -v" to see if you made it right or not!

[smemamian]

this is correct ?

variable value : C:\TCWIN45\BIN;C:\Qt\Qt5.0.0\5.0.0\msvc2010\bin\qmake

variable value : C:\TCWIN45\BIN;C:\Qt\Qt5.0.0\5.0.0\msvc2010\bin\qmake

To copy to clipboard, switch view to plain text mode 

[alizadeh91]

just don't remove any character in "variable value" field. just put a simicolon at end and paste qmake address (C:\Qt\Qt5.0.0\5.0.0\msvc2010\bin don't put qmake at end of address)

[smemamian]

Tnx , Hooray\:d/

variable value : C:\TCWIN45\BIN;C:\Qt\Qt5.0.0\5.0.0\msvc2010\bin;

---

Added after 12 minutes:

nmake

nmake

To copy to clipboard, switch view to plain text mode 

'nmake' is not recognized as a internal or external command ,
operable program of batch file

i hasn't nmake in C:\Qt\Qt5.0.0\5.0.0\msvc2010\bin address for add to environment variables (

[BalaQT]

hi,

i hasn't nmake in C:\Qt\Qt5.0.0\5.0.0\msvc2010\bin address for add to environment variables

just find nmake using a search explorer and set the path

hope it helps,
Bala

[alizadeh91]

Instead of cmd you can use "visual studio command prompt" (just search it in start menu and open it). It recognize nmake by itself

[smemamian]

hi,


just find nmake using a search explorer and set the path

hope it helps,
Bala

No items match your search

---

Added after 4 minutes:

Instead of cmd you can use "visual studio command prompt" (just search it in start menu and open it). It recognize nmake by itself

Very thanks .

[alizadeh91]

use visual studio command prompt