I Need help in cross compiling Qt with firebird step by step

daliusd

Look. To ./configure you pass:

-L/fbc/usr/lib/linux-arm-gnueabi

and later write that fbs looks like this:

/fbc/usr/lib/arm-linux-gnueabi/

Maybe that's why it cannot find fbclient lib.

Qt Nico

hmmm. I still have no luck cross compiling Qt with interbase enabled. thanks again daliusd.

Qt Nico

Does enabling tslib in Qt have the same procedure in enabling interbase while cross-compiling? here is the link on building tslib http://importgeek.wordpress.com/2012/04/09/compiling-qt-and-tslib-for-mini2440-and-run-a-demo-app/

daliusd

I guess there might be some similarities but tslib looks like special enough case http://doc.qt.digia.com/qt/qt-embedded-pointer.html to be worth documented. DB client shouldn't be problematic - the only problem in your current workflow I see currently is that you have downloaded armel library from internet. I'm not sure what's your next problem (if library was found) but the only way to solve this for you by solving problem one-by-one until you succeed.

Qt Nico

I tried to set config.tests/unix/ibase/ibase.pro into
LIBS += -/fbc/usr/lib/arm-linux-gnueabi

and I ran this configuration:

./configure -embedded arm -prefix /ext -xplatform qws/linux-arm-gnueabi-g++ -no-qt3support -qt-sql-ibase -v -no-webkit -no-phonon -I/fbc/usr/include/

And it actually enabled interbase as a plugin and enabled me to makefile and make install Qt.

Now, I've already compiled my code without getting any errors. and then I transferred all the libraries and all the necessary files that I think the embedded control board is needed. But when I ran the executable file on the device. it say's:

QSqlDatabase: QIBASE driver not loaded
QSqlDatabase: available drivers: QSQLITE

NOTE:
"executable file type: ELF 32-bit LSB executable, ARM, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.14, not stripped"

I have a question regarding of what I do not know. what is the purpose
and importance of "-l" in the "LIBS += -lfbclient" and does not getting any error while configuring Qt assures that it is successful?

daliusd

When you build app process takes two steps:

compile (convert source code files to object files)
linking (combine object files and libraries into executable or library).

"LIBS +=" basically lists libraries that must be linked into executable. If you will skip necessary library it should give you linking error and complain (try it). If it is successful everything is OK (I think). It is hard to say why it is not working - I have never compiled custom DB plugin myself. I can guess only: it is looking for DB plugin in wrong place, it fails to load plugin because of some random error (e.g. expects some other library, like glib, not enough memory or anything else). You might try catching problems like this using gdb but that might too advanced at this stage.

For now here is something I have found and I think might be useful for you:
http://qt-project.org/doc/qt-4.8/sql-driver.html

Qt Nico

I am trying an alternative to connect firebird with Qt. but I still encountering a problem. I am trying to use IBPP (interbase ++).

Here is my Qt with IBPP code:

#include "/ibpp/core/ibpp.h"
#include <iostream>
#include <QApplication>
#include <QtSql>
#include <QDebug>
#include <string>

int main(int argc, char *argv[])
{
QApplication a(argc, argv);

IBPP::Database ibpp = IBPP::DatabaseFactory("localhost","/db.fdb","SYSDBA","masterkey");
ibpp->Connect();

return a.exec(&#41;;

}

But there are 3 issues:

/home/esn/SQSP/sqs-build-Desk2-Release/main.o:-1: In function `IBPP::DatabaseFactory(std::string const&, std::string const&, std::string const&, std::string const&)':

/ibpp/core/ibpp.h:874: error: undefined reference to `IBPP::DatabaseFactory(std::string const&, std::string const&, std::string const&, std::string const&, std::string const&, std::string const&, std::string const&)'

:-1: error: collect2: error: ld returned 1 exit status

daliusd

Here you are missing libraries. ld is GNU linker (type "man ld" in terminal). You should add appropriate libraries to LIBS += ...

Qt Nico

I feel dizzy this time, I think I need to rest now. I'll try to come back here tomorrow. daliusd, Thank you very much.

Qt Nico

I cannot execute this tutorial completely on how to Make Qt applications work with Firebird database: http://rongsheng007.wordpress.com/2010/08/23/make-qt-applications-work-with-firebird-database/

Can somebody test it and tell me if it is working? thanks

daliusd

Nico, try contacting person who wrote that article. He/She might help you more than us.

Qt Nico

ok, thanks daliusd! :)

MichelSM

I'm trying to do this but I can not also
IBBP also uses tried but did not work

MichelSM

Please advise if you find something,
I used that example but giving this error with memset and memcpy
anyone have any idea what it might be?
I'm using Qt 5.2 ....
will these functions were taken?
never used them ...

Qt Nico

Oh, this is a long time ago. I'd able to make Firebird to work in Qt running over a ARM architecture microcontoller by switching from Angstrom distribution to Ubuntu distribution.