use qpsql

[raphaelf]

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

[jacek]

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.

[raphaelf]

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
Mission Impossible..

[jacek]

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?

[raphaelf]

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?

[jacek]

What is a build key?

It's a special string that you can assign to your Qt DLLs and plugins. When Qt loads a plugin it checks whether both keys are the same, but since you have never heard about it, you have probably probably left the default values, so it shouldn't be a problem.

Open libeay32.dll and libpq.dll in Dependency Walker and see if there are some DLLs missing. If it finds some, post them here.

[raphaelf]

Hi,
libeay32.dll seems to miss nothing
libpq.dll seems to miss (i get a yellow question mark):
- COMERR32.DLL
- LIBINTL-2.DLL
- KRB5_32.DLL
- SSLEAY32.DLL

If i open LIBPQ.DLL from the original path: D:\apps\PostgreSQL\8.1\bin then its missing nothing..

[jacek]

If i open LIBPQ.DLL from the original path: D:\apps\PostgreSQL\8.1\bin then its missing nothing..

Then copy all missing DLLs from D:\apps\PostgreSQL\8.1\bin to the directory where your executable is.

[ball]

Just put those DLL into c:\windows\system32\

[jacek]

Just put those DLL into c:\windows\system32\

This is a bit dangerous solution. What if there is another program that uses those DLLs, but for example their older versions?

[ball]

Yeah you are right but in this case, we need to make his program get running as first priority problem to be solved.

[raphaelf]

Hi everybody
I put the dlls where my .exe is and i get the same error: driver not loaded..
I really dont know what to do now

P.S. If i start the sql browser example, i can just see: qsqlite and qodbc, but no qsqlpsql. Did this information help??

Please help me to solve my problem..With QT3.2.1 i could connect me without problem to a postgre database..

[jacek]

I put the dlls where my .exe is and i get the same error: driver not loaded..

Check all DLLs you have copied with Dependency Walker(you might be missing libiconv-2.dll).

The other solution is to recompile Qt with -qt-sql-psql option, so that the driver will be compiled into the library. This way when you start your application it should tell you what DLLs are missing.

[raphaelf]

Hi Jacek,
I think its a good idea..
Should i type this comand to configure it:
configure -qt-sql-psql
make

Or should i deinstall QT and install it again?

[jacek]

Should i type this comand to configure it:
configure -qt-sql-psql

And then "make", but it will take few hours. Make a copy of your current Qt directory, so that you won't have to recompile it again.

Checking with Dependency Walker will take at most few minutes.