Need to connect C++ application with web database

Need to connect C++ application with web database

Hello Allan!

There are several ways for you to connect database and your C++ application. Adding few sets of codes is a very easy task. Here I will use Sql Server database connected to it. We will not require any connection setup here, we are going to call the database using the usual set of commands. This also works with VB applications.

…

#include <QtSql>

…

int main(int argc, char *argv[])

{

    ….

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

    db.setDatabaseName("DRIVER={SQL Server};Server=SERVER NAME;Database=YOUR DB NAME;User ID=admin;Password=admin;Trusted_Connection=yes;");

    if(!db.open())

    {

       qDebug() << db.lastError().text();

       return 0;

    }

    ….

}

Explanation:

The first thing that you need to do is to set up your Sql Server. If you already installed the server in you computer and haven’t tried it yet, I am sure that your Username is “admin” and Password is “admin” also. On lines 8 and 9, you see the server=YOUR SERVER NAME. You just have to open and check for the server name in your Sql Server. Replace that with the server name and same thing that you have to do with username and password. This is confirmed a working code and have gone through this many times and it is durable. I have tried to run some queries with this in multiple computers though, if there’s an instance that your queries in multiple computers will have same time of query, the other computer will not show data, you just have to repeat it again.