PostgreSQL and Trying to connect using Qt

[aftertaf]

http://pastebin.com/4cpqVMiN
folder contents

[clochydd]

Thanks for the data! I can see our "fatal" libpq-fe.h in c:\psql93_x86\include. So as a first step I suppose to test with:
C:\QT\5.2.1\Src\qtbase\src\plugins\sqldrivers\psql>c:\Qt\5.2.1\mingw48_32\bin\qmake.exe “INCLUDEPATH+=c:\psql93_x86\include” “LIBS+=c:\psql93_x86\lib\libpq.lib” psql.pro
I know, the backslashes are a bit unusual for Qt but it worked with my installs so give it a try! Good luck!

[aftertaf]

i've tried on many occasions with \ and /: same result.

The problem is obviously over my level of unkludging, and I've figured out how to use ODBC instead.

@
#include <QtSql>
#include <QString>
#include <QSqlDatabase>

void connect_db()
{

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
QStringList driversList = QSqlDatabase::drivers();
qDebug() << "drivers list= " << driversList;
bool bOpen(false);
db.addDatabase("QODBC","odbcname");
db.setHostName("localhost");
db.setDatabaseName("dbname_in_postgres");
db.setUserName("username");
db.setPassword("password");
bOpen =db.open();
QString str=db.lastError().text();
}@

str remains empty :)
and bOpen shows True for the first time in a month's trying.
I dont need pure pg connection, using an ODBC is fine for me at this stage.
Now for trying to make my DAO classes :)
thanks to all for helping, sorry it didn't work out as intended, but for ODBC connections, my above code works.

[Duncan]

Hello!

What did you put for this line:

db.addDatabase("QODBC","odbcname");

Not sure what to put instead of odbcname.

Thanks!

[clochydd]

Hello Duncan,

if you only open one database, you do not need to specify the connection name:

db.addDatabase("QODBC");

If you plan work with more connections, use a name to identify each connection:

db.addDatabase("QODBC","myConn1");

[SGaist]

Hi,

addDatabase is a static function that returns a QSqlDatabase instance that will use the selected backend.

So you must call it like that:
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC")

The suggestion of @clochydd about the connection name still applies.