[SOLVED]can't find the "src" directory to build my QPSQL driver

[k_arnaud]

Hi,
i've a problem with my Qt application when trying to use a PostgreSQL database. here is the error message i'm getting: QSqlDatabase: QPSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7.
i've found "here":http://qt-project.org/doc/qt-4.8/sql-driver.html#qpsql a way to build a QPSQL driver but, i don't have any directory named "src" in my Qt installed directory.
can someone help me.
Thanks!

[SGaist]

Hi and welcome to devnet,

It's because you didn't installed the sources. You can grab them from the download page. Just ensure that it matches your current installed Qt.

[k_arnaud]

ok, thanks but i download Qt with the installer, how can i get sources

[clochydd]

Hi, you can download the sources "here: ":http://qt-project.org/downloads

[k_arnaud]

ok thanks! i'm downloading the sources, how can install them or i have to copy the src directory in my Qt installed directory ?

[clochydd]

Maybe "this ":http://qt-project.org/forums/viewthread/34609/ will help you.

[clochydd]

Hi k_arnaud,

I wrote a small tutorial for setting up Qt5.2.1/mingw + PostgreSQL 32-Bit on Win7 - hope it will help:

1. Prepare compiling of the plugin (Lets assume we install Qt + Sources to C:\Qt, PostgresSQL to C:\Programs(86x)):

2. Download Qt 5.2.1 32-bit: http://download.qt-project.org/official_releases/qt/5.2/5.2.1/qt-opensource-windows-x86-mingw48_opengl-5.2.1.exe

3. Run the .exe, install to C:\Qt\Qt5.2.1

4. Download sources: http://download.qt-project.org/official_releases/qt/5.2/5.2.1/single/qt-everywhere-opensource-src-5.2.1.zip

5. Extract zip to C:\Qt\Qt5.2.1

6. Download PostGreSQL 32-bit: http://www.enterprisedb.com/postgresql-932-1-installers-win32?ls=Crossover&type=Crossover

7. Modify PATH:
   set QTSDK_SQLDRIVERS_PATH=C:\Qt\Qt5.2.1\5.2.1\mingw48_32\plugins\sqldrivers
   set QT_SRC_PATH=C:\Qt\Qt5.2.1\5.2.1\Src\qtbase
   set POSTGRES32=C:\Progra~2\PostgreSQL\9.3 (USE Progra~2 FOR Programs(86x)!)

8. cd QT_SRC_PATH\src\plugins\sqldrivers\psql

9. add permanently to PATH (Control Panel): C:\Qt\Qt5.2.1\Tools\mingw48_32\bin

10. modify C:\Progra~2\PostgreSQL\9.3\include\pthread.h (multiple definitions of struct timespec):
    replace: #ifndef HAVE_STRUCT_TIMESPEC
    with: #if ((!defined(_TIMESPEC_DEFINED)) && (!defined(HAVE_STRUCT_TIMESPEC)))

11. start building the plugins:
    C:\Qt\Qt5.2.1\5.2.1\mingw48_32\bin\qmake “INCLUDEPATH+=%POSTGRES32%\include” “LIBS+=%POSTGRES32%\lib\libpq.lib” psql.pro
    mingw32-make debug
    mingw32-make release

12. copy the newly created plugins to C:\Qt\Qt5.2.1\5.2.1\mingw48_32\plugins\sqldrivers:
    copy release\libqsqlpsql.a QTSDK_SQLDRIVERS_PATH
    copy release\qsqlpsql.dll QTSDK_SQLDRIVERS_PATH
    copy debug\libqsqlpsqld.a QTSDK_SQLDRIVERS_PATH
    copy debug\qsqlpsqld.dll QTSDK_SQLDRIVERS_PATH

[k_arnaud]

ok thank Clochydd Clochydd i'll try, but i've a Windows 8 64 bit and PostgreSQL9.3 64 bits. I do hope it will work.
thank !

[clochydd]

Then you can only use this tutorial as a very rough guide as you do not work with the 32-Bit mingw, too.

[k_arnaud]

Hi Clochydd Clochydd
i downloaded PostgreSQL 32 bit and i tried to follow what you've written. but i can't undersdands the #7, when you say . " Modify PATH:
set QTSDK_SQLDRIVERS_PATH=C:\Qt\Qt5.2.0\5.2.1\mingw48_32\plugins\sqldrivers
set QT_SRC_PATH=C:\Qt\Qt5.2.1\5.2.1\Src\qtbase
set POSTGRES32=C:\Progra~2\PostgreSQL\9.3 (USE Progra~2 FOR Programs(86x)!)" and more of the following

when you asked me to run the .exe installed in Qt installed dir, did you mean Qt creator ? if not which .exe i should run ? thanks

[clochydd]

Hi k_arnaud,
sorry, I made a mistake: It should read "Modify environment" as the variables have to be added. You should set these entries in the CMD-window and have a look at the correct paths - relating to your system.

[k_arnaud]

ok, but when you said run the .exe, do you mean Qt creator ?

[clochydd]

I'm sorry but I do not understand. What do you mean with run the .exe?

[k_arnaud]

about the #11 i've installed Qt with msvc2010 not mingw32

[clochydd]

If you have installed with msvc2010 you cannot work with the 32-Bit postgres. I never worked with msvc2010.

[k_arnaud]

ok i'll try with mingw32. thanks

[k_arnaud]

Hi Clochydd, i've downloaded Qt with mingw32...
About the #11 here is the error message i get: "cannot find file psql.pro"

[clochydd]

Hi k_arnaud, the message says that the project file for building the plugin cannot be found.
Did you go to the plugins directory:
8. cd QT_SRC_PATH\src\plugins\sqldrivers\psql
If so, does the psql.pro exist here?

[k_arnaud]

after entering mingw32-make debug , in the unreadable message i get, i can see makefile:48: recipe for target 'debug' failed and i get the same with release

[clochydd]

You should check your pathnames again - it seems that dependencies cannot be found. If you cannot find a fault: What is the unreadable message?