Problem compiling QDB2 SQL driver

[vieraci]

I recently installed IBM DB2 ver 9.7 and the development library.
I went to the Qt src/plugins/sqldrivers/db2 directory and modified the pro file to get all the compile errors I could out:

TARGET	 = qsqldb2
 
HEADERS		= ../../../sql/drivers/db2/qsql_db2.h
SOURCES		= main.cpp \
		  ../../../sql/drivers/db2/qsql_db2.cpp
INCLUDEPATH+=/opt/ibm/db2/V9.7/include
LIBS+=-L/opt/ibm/db2/V9.7/lib32 -ldb2
 
# unix:!contains( LIBS, .*db2.* ):LIBS 	*= -ldb2
# win32:!contains( LIBS, .*db2.* ):LIBS   *= -ldb2cli
 
include(../qsqldriverbase.pri)

TARGET	 = qsqldb2

HEADERS		= ../../../sql/drivers/db2/qsql_db2.h
SOURCES		= main.cpp \
		  ../../../sql/drivers/db2/qsql_db2.cpp
INCLUDEPATH+=/opt/ibm/db2/V9.7/include
LIBS+=-L/opt/ibm/db2/V9.7/lib32 -ldb2

# unix:!contains( LIBS, .*db2.* ):LIBS 	*= -ldb2
# win32:!contains( LIBS, .*db2.* ):LIBS   *= -ldb2cli

include(../qsqldriverbase.pri)

To copy to clipboard, switch view to plain text mode 

I get 2 warnings:

/home/vince/Downloads/Qt/qt-x11-opensource-src-4.5.2/src/plugins/sqldrivers/db2/../../../sql/drivers/db2/qsql_db2.cpp:1479: warning: enumeration value ‘FinishQuery’ not handled in switch
/home/vince/Downloads/Qt/qt-x11-opensource-src-4.5.2/src/plugins/sqldrivers/db2/../../../sql/drivers/db2/qsql_db2.cpp:299: warning: ‘double qGetDoubleData(SQLHANDLE, int, bool&)’ defined but not used

Deciding to ignore for now, I copied the library file to the /usr/share/qt4/plugins/sqldrivers directory but my app doesn't load the driver and the output indicates that the QDB2 driver isn't amongst the available drivers.

Anyone know what the problem is ?
Could the warnings stop the driver from loading ?

[Lykurg]

Anyone know what the problem is ?

Yes, bad programmers (for the warnings)

Could the warnings stop the driver from loading ?

No, both warnings are harmless. You can ignore them. Why your driver is not loaded? The error must be somewhere else.

[vieraci]

Well I've discovered the driver loads ok when I invoke the app from a command prompt but not from QT Creator IDE.

[vieraci]

In fact, it appears that the db2 driver is present, but fails at db.open().

if (!QSqlDatabase::drivers().contains("QDB2"))
    {
        QMessageBox::critical(0, "Unable to load database", "This application needs the QDB2 driver");
        return -1;
    }
 
     QSqlDatabase db = QSqlDatabase::addDatabase("QDB2");
     db.setHostName("host");
     db.setDatabaseName("myDB");
     db.setUserName("me");
     db.setPassword("pwd");
     if (! db.open()) 
     {
          // db fails to open !!
     }

if (!QSqlDatabase::drivers().contains("QDB2"))
    {
        QMessageBox::critical(0, "Unable to load database", "This application needs the QDB2 driver");
        return -1;
    }

     QSqlDatabase db = QSqlDatabase::addDatabase("QDB2");
     db.setHostName("host");
     db.setDatabaseName("myDB");
     db.setUserName("me");
     db.setPassword("pwd");
     if (! db.open()) 
     {
          // db fails to open !!
     }

To copy to clipboard, switch view to plain text mode 

This is most annoying as I can't debug the rest of the app from within the IDE

[schnitzel]

Well I've discovered the driver loads ok when I invoke the app from a command prompt but not from QT Creator IDE.

that's probably because on the command prompt your db2 client dll can be found, not so in Qt Creator.

Try putting the db2 client dll into your debug(or release) folder as a test.

[vieraci]

I already tried that
Maybe I need to try to find a way to add the path in the ide ?

[schnitzel]

do any of the sql examples work from within qt creator?

There is a difference between linux/windows on where to put the libs/dlls. I think on linux, you need to put them in the project directory, not in debug/release but you probably knew that (judging by your number of posts).

also, see if this is helpful:
http://www.qtcentre.org/forum/f-qt-t...tor-25149.html

[vieraci]

The examples use MySQL and yes, they run fine. It's a DB2 specific problem.