use qpsql

Hi everybody,
QT: 4.1.3
OS: WIN XP

I tried to connect to my sql server via odbc and it works perfect. I have installed postgre 8.1 on my machine and build the plugin for postgre. I get a new file "qsqlpsql.dll". So i would like to connect it to a Postgre database. I get the known error: Driver not loaded, driver not loaded.
Here my code:

Code:

---

QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
        db.setHostName("localhost");
        db.setDatabaseName("inventar");
        db.setUserName("postgres");
        db.setPassword("tekoteko");
        if(!db.open())
        {
    	QMessageBox::information(this,"",db.lastError().text());
        return false;
    	}    
        else
        {
        . . .

---

What could i try to make my connection running?

Thanks :crying:

Check the dependencies of the driver using dependency walker. Maybe the plugin can't find some library it needs.

Hi wysota!!
I downloaded dependency walker and check qsqlpsql.dll
I get a yellow question mark for "LIBPQ.dll", what should i do now? :o

Quote:

---

Originally Posted by raphaelf

I get a yellow question mark for "LIBPQ.dll", what should i do now? :o

---

Find it and copy to the same directory where the executable is.

Hi Jacek,
I copyed the dll to the directory and i get the same error "driver not loaded" :crying:

Quote:

---

Originally Posted by raphaelf

I copyed the dll to the directory and i get the same error "driver not loaded" :crying:

---

AFAIR you need more than one DLL. Check what DLLs libpq.dll requires.

Hi Jacek,
I copied all dlls from postgres and i get the same error :crying:
With QT3.2.1 i can remenber that i had no problem to connect me to my postgre database.
Do QT4 support Postgre 8.1?
What could i try now?? :confused:

Quote:

---

Originally Posted by raphaelf

Do QT4 support Postgre 8.1?

---

Of course it does. Which Qt version do you have exactly?

Hi!!
QT4.1.3 Open Source Edition
MINGW 4.1 :crying:

Quote:

---

Originally Posted by raphaelf

QT4.1.3 Open Source Edition

---

I had no problems with this version. To be able to load the plugin, I had to add libeay32.dll, libpq.dll and libssl32.dll

Hi everybody :crying:
I add these dlls to my path: libeay32.dll, libpq.dll and qsqlpsql.dll
I could not find libssl32.dll on my system.
but i am not able to connect to my postgre databse. What could i try to solve my problem?

Code:

---

QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
        db.setHostName("localhost");
        db.setDatabaseName("inventarMp");
        db.setUserName("postgres");
        db.setPassword("");
        if(!db.open())
        {
    	QMessageBox::information(this,"",db.lastError().text());
        return false;
    	}     
        else
        {..

---

ERROR: Driver not loaded :crying:

hi everybody,
can somebody see why i am not able to connect me to a postgre database :confused:

thanks

Where did you place the plugin and PostgreSQL DLLs?

hi jacek,
i add libeay32.dll, libpq.dll and qsqlpsql.dll there where my .exe file is (in the release folder) :o

have you a idea?

Then move qsqlpsql.dll to the sqldrivers subdirectory.

hi jacek,
this dll is allready under: D:\apps\Qt\4.1.3\plugins\sqldrivers
:o

Quote:

---

Originally Posted by raphaelf

this dll is allready under: D:\apps\Qt\4.1.3\plugins\sqldrivers

---

Then copy it to the sqldrivers subdirectory of the directory where your executable is.

Hi Jacek,
I create the sqldrivers directory, copy this dlls: libeay32.dll, libpq.dll, qsqlpsql.dll
I get the same error message: DRIVER NOT LOAD DRIVER NOT LOAD :crying:
Mission Impossible..:confused:

Quote:

---

Originally Posted by raphaelf

I create the sqldrivers directory, copy this dlls: libeay32.dll, libpq.dll, qsqlpsql.dll

---

Only qsqlpsql.dll should go the sqldrivers, the rest should remain in the same directory where your executable is.

Did you compile the plugin and Qt with the same compiler and same build key?

Hi!
I put just qsqlpsql.dll now in my sqldrivers directory.
Yes i have compiled QT and Plugin with the same Compiler.

What is a build key?