How I can activate QODBC in Qt4 for windows

[vcp]

Hi,

That is, the nokia doesn't compile the sdk for windows that supports ODBC, you have to recompile the sdk to get it.
If it is, I think nokia is wrong in this attitude. This will only hinder, not help, nothing at all!

Thanks

[ChrisW67]

Qt SDK 2009.03 already has built and functional QODBC driver support out-of-the-box.
Qt SDK 2010.02.1 already has built and functional QODBC driver support out-of-the-box.
I have deployed ODBC-using applications using both of the above without ever rebuilding any part of Qt on Windows.

The copy of Qt SDK 2010.04 I just downloaded has ODBC support built out-of-the-box. Open Windows Explorer, navigate to your equivalent of "C:\Qt\2010.04\qt\plugins\sqldrivers", observe qsqlodbc4.dll and qsqlodbcd4.dll.

#include <QtCore>
#include <QtSql>
#include <QDebug>
 
int main(int argc, char *argv[])
{ 
    QCoreApplication app(argc, argv);
 
    qDebug() << QSqlDatabase::drivers();
    return 0;
}

#include <QtCore>
#include <QtSql>
#include <QDebug>

int main(int argc, char *argv[])
{ 
    QCoreApplication app(argc, argv);

    qDebug() << QSqlDatabase::drivers();
    return 0;
}

To copy to clipboard, switch view to plain text mode 

and its output:

Starting C:\temp\debug\temp.exe...
("QSQLITE", "QODBC3", "QODBC")

Starting C:\temp\debug\temp.exe...
("QSQLITE", "QODBC3", "QODBC")

To copy to clipboard, switch view to plain text mode 

No amount of you repeating that Qt SDK doesn't include ODBC out-of-the-box will make it so.

[vcp]

hi,

I installed 2010.04 and realy saw the dlls, but when I compile your example or other code
SqlDatabase:: drivers () shows:

("QSQLITE", "QMYSQL3", "QMYSQL")
 
// if I try open a database
QSqlDatabase: QODBC driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL3 QMYSQL
QSqlError(-1, "Driver not loaded", "Driver not loaded")

("QSQLITE", "QMYSQL3", "QMYSQL")

// if I try open a database
QSqlDatabase: QODBC driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL3 QMYSQL
QSqlError(-1, "Driver not loaded", "Driver not loaded")

To copy to clipboard, switch view to plain text mode 

There is, perhaps, some explanation for this behavior?

Thanks a lot

[vcp]

Hi (again) all,

After searching a lot, I would put in this forum, for my solution to: ODBC Driver not loaded problem in WindowsXP using Qt 2010.0x

Compiling odbc modules and placing them in the right places, they were not loaded.
Searching within files Configure.cache and .gmake (Qt\2010.0x\qt) and I noticed that the use of instruction sql-plugins + = odbc. So I put this option in my .pro file.
I compiled the application and the result was that the odbc was successfully activated.

("QSqlLite "," QODBC3 "," QODBC "," QMYSQL3 "," QMYSQL")

So, if any of you are having a similar problem try using in the .pro file the instruction:

src.pro:

sql-plugins += odbc

bye.

[ChrisW67]

There is, perhaps, some explanation for this behavior?

The only explanation for this is that the program is running with libraries other than the ones shipped in the SDK. The libraries shipped in the SDK give the result in my earlier post. The dead give away is that the Qt SDK (Windows) does not have any MYSQL support out-of-the-box. If you really want to find out what is going on try using Dependency Walker and/or Process Monitor on your executable running in the environment in which it fails.

I'll say it once again. You do not have to build any part of Qt in order to get ODBC support with the Mingw-based Qt SDK on Windows. It is there out of the box. You need do nothing more than add:

CONFIG += sql

CONFIG += sql

To copy to clipboard, switch view to plain text mode 

to your PRO file to link the relevant libraries, and make sure when you deploy the correct libraries and drivers go with it.