Database Connection Problem

[bagavathikumar]

I am working in a database project using MYSQL with Qt. My application is connecting with database, If Qt and MySQL are in the same PC. But If I run my application from another PC and I am trying to connect to the database through ethernet, It is not connecting. This is my connection code:

@ m_sqlDB = QSqlDatabase::addDatabase("QODBC");
m_sqlDB.setDatabaseName("Driver={MySQL ODBC 5.1 Driver};Server=10.3.3.102;DATABASE=ADTL;");
m_sqlDB.setUserName("root");
m_sqlDB.setPassword("abcdef");

if (!m_sqlDB.open()) {
    QMessageBox::critical(0, qApp->tr("Cannot open database"),
        qApp->tr("Unable to establish a database connection.\n"
                 "Click Cancel to exit."), QMessageBox::Cancel);
    return ;
}@

Kindly guide me, what i am missing.

Thanks & Regards
Bagavathikumar

[SGaist]

Hi,

Did you deploy all needed dlls with your application on the other computer ?

[bagavathikumar]

My application is working correctly, but the problem is in when i am calling the 'Open' API (QSqlDatabase). Basically my setup is like this:

I have a two computers and both are connected to local intranet.

Computer 1: I installed MySQL 5.5, MySQL ODBC 5.1 Driver and Qt 5.2. When I execute my code in this computer, The Application is connecting to the database without any problem.

Computer 2: I installed only Qt 5.2. When I execute my code in this computer, the database Open API gets failed. Because Database is resides in Computer 1 and I am using IP address of Computer 1 in my code.

Now I want to know whether I need to install ODBC driver in the Computer 2? or anything else is required to connect the remote database using ODBC method.

[bagavathikumar]

Finally my application is connecting to the database, after install the MySQL ODBC 5.1 Driver in the Computer 2.

But How do I ensure the required ODBC drivers are installed in the computer, when I deploy the application. Or what are the dll files required to include in my installation for ODBC?

Thanks & Regards
Bagavathikumar

[MisteKiste]

You mean the sql driver?

[SGaist]

Also, did you setup your database to allow connection from other computers ?

[bagavathikumar]

bq. You mean the sql driver?

Yes

bq. Also, did you setup your database to allow connection from other computers ?

I've not done any setup. I installed the MYSQL 5.5 with MySQL ODBC 5.1 Driver in computer 1 and only MySQL ODBC 5.1 Driver in Computer 2.

[SGaist]

Then check first that your database accepts connections from an external computer