Qt 4.8.5 with PostgreSQL 9.1 !!

[NandiniN]

Hello kindly help...

I have PostgreSQL 9.1 and Qt Designer both are running very fine individually.. Please help me to CONNECT THESE TWO!! Which loaders should i use,why should i do that..how to set the path,where to set etc

[mcosta]

Hi,

Qt Designer is a UI designer there isn't DB connection.

If you mean how to connect Qt application with DB, read "here":http://qt-project.org/doc/qt-5.1/qtdoc/topics-data-storage.html#sql-support-in-qt for an overview and "here":http://qt-project.org/doc/qt-5.1/qtsql/sql-driver.html#qpsql-for-postgresql-version-7-3-and-above for PostgreSQL related information

[NandiniN]

Following your link, i am not able to do 'nmake'..it gives me fatal error NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio 9.0
VC\BIN\cl.EXE"' : return code '0x2'
Stop.

what is wrong?

[mcosta]

Wich version of Qt are you using? What Operaing System?

If you're using Windows/MinGW you shall follow Unix instruction to build PSQL driver

[NandiniN]

Qt 4.8.5 .Windows 7 ,64bit. I have been using only Qt designer and i run c++ code on VS2008. I haven't installed Qt Creator yet, is it giving me problem?

Installed MinGW 3.1.0 and tried following this https://sites.google.com/site/qxormpostgres/generar-driver-postgres-qt
got struck in 9yh step,i am not able to generate '.a' files !

Please elaborate on this "If you’re using Windows/MinGW you shall follow Unix instruction to build PSQL driver".

[mcosta]

Hi,

I means "What Qt build are you using"? The answer is Qt-VisualStudio.

You can't mix compiler. You must use VisualStudio.

Anyway, "here":http://msdn.microsoft.com/en-us/library/xsyc3e16(v=vs.110).aspx you can read that return code 0x2 probably means that your Makefile is incorrect.
Is the cl.exe PATH correct?

Please post you configuration and the prompt command you used to run qmake

[NandiniN]

I have no idea about this cl.exe !

came up with new issue-
C:\Qt\4.8.5>C:\Qt\4.8.5\src\plugins\sqldrivers\psql

C:\Qt\4.8.5\src\plugins\sqldrivers\psql>qmake Makefile "INCLUDEPATH+=C:/Program
Files/PostgreSQL/9.2/include" "LIBS+=C:/Program Files/PostgreSQL/9.2/lib/libpq.a
" psql.pro
i get something like this -

c:\Qt\4.8.5\src\plugins\sqldrivers\psql\Makefile:9: Parse Error ('first: debug')

Error processing project file: Makefile

C:\Qt\4.8.5\src\plugins\sqldrivers\psql>

[mcosta]

Hi

from
@qmake Makefile “INCLUDEPATH+=C:/Program Files/PostgreSQL/9.2/include” “LIBS+=C:/Program Files/PostgreSQL/9.2/lib/libpq.a “ psql.pro
@

delete Makefile word

@
qmake “INCLUDEPATH+=C:/Program Files/PostgreSQL/9.2/include” “LIBS+=C:/Program Files/PostgreSQL/9.2/lib/libpq.a“ psql.pro
@

[NandiniN]

C:\Qt\4.8.5\src\plugins\sqldrivers\psql>qmake "INCLUDEPATH+=C:/Program Files/Pos
tgreSQL/9.2/include" "LIBS+=C:/Program Files/PostgreSQL/9.2/lib/libpq.a" psql.pr
o
Cannot find file: Files\PostgreSQL\9.2\includeö.
Cannot find file: Files\PostgreSQL\9.2\lib\libpq.aô.

C:\Qt\4.8.5\src\plugins\sqldrivers\psql>

how to generate this ".a" files?

[mcosta]

Hi,

as you can see, there is a problem with path containing spaces; try to prefix a '' character to each space.

For example

@
qmake “INCLUDEPATH+=C:/Program\ Files/PostgreSQL/9.2/include” “LIBS+=C:/Program\ Files/PostgreSQL/9.2/lib/libpq.a“ psql.pro@

[SGaist]

Hi,

The quickest way to avoid problems with LIBS paths on windows is to either avoid using spaces at all or use the 8.3 naming

[mcosta]

Hi,

to get 8.3 names you can type on Windows Command Prompt

@
dir /X
@