use qpsql

[raphaelf]

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:

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
        {
        . . .

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
        {
        . . .

To copy to clipboard, switch view to plain text mode 

What could i try to make my connection running?

Thanks

[wysota]

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

[raphaelf]

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

[jacek]

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

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

[raphaelf]

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

[jacek]

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

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

[raphaelf]

Hi Jacek,
I copied all dlls from postgres and i get the same error
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??

[jacek]

Do QT4 support Postgre 8.1?

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

[raphaelf]

Hi!!
QT4.1.3 Open Source Edition
MINGW 4.1

[jacek]

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

[raphaelf]

Hi everybody
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?

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
        {..

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
        {..

To copy to clipboard, switch view to plain text mode 

ERROR: Driver not loaded