[solved] ZConnection.libraryLocation

[EgonHugeist]

elidorio2,

hey Edson, i'm not able to see what's going wrong! Everything is fine. So i'm sure that your problem can only be uncompatible dll's on this PC. So please scan this system for these dll's, be sure the dll you want to use is unique. Delete all dll's which are not from the bin directory. Evantually change the path envirnoment variable and add the PostgreSQL bin dir. Or follow ism's instructions.

Michael

[elidorio2]

Hello Michael,

Do not worry, have not figured out the problem with windows xp on this machine, it must be some peculiarity in this machine, I tested on another machine worked. I performed the procedures indicated that the Ism and still did not work.

Thank you,

Edson

[ism]

Maybe problem with environment variables or antivirus

[miab3]

@elidorio2

Most likely you have not installed the appropriate Microsoft Visual C + + Redistributable Package.

Michal

[elidorio2]

Hello Michal,

Really missing the Visual C + + 2010 Redistributable Package.
Problem solved.
Thank you all,

Edson

[JanPijnacker]

Hello everybody,

I'm a brand new Lazarus/ZeosLib/PostgreSQL user and I do have the same problems as described in this thread.

This is the configuration, everything 64-bit:
- Windows 7 SP1
- PostgreSQL 9.0.10
- ZeosLib 7.0.1-beta
- Lazarus IDE v1.0.2 with FPC 2.6.0

I made a small project with a ZConnection component. And when TZConnection.Connected is set to True, I will get two error messages.

1. The program can't start because libintl-8.dll is missing from your computer. Try reinstalling the program to fix this problem.

2. None of the dynamic libraries can be found or is not loadable: C:\Program Files (x86)\PostgreSQL\9.0\bin\libpq.dll !
Use TZConnection.LibraryLocation if the location is invalid.

I did try all the solutions provided in this thread. Copying the dll's to the project folder, installing Visual C++ Redistributable, etc. I also did reinstall PostgreSQL but nothing changed (except for losing my database because I forgot to make a backup:)).

Why do I get error message 1? Is this something from an older PostgreSQL 8 installation? Because I did have that on my laptop a couple of months ago before I did upgrade to version 9.0.10. And do you think if I get rid of that one, error message 2 will also disappear?

[elidorio2]

already gone through this problem, two possible solution

- Create a path from the bin folder of the environment variables in postgresql
- Install the vcredist_x64.exe that the installer of postgresql.

[JanPijnacker]

Hi elidorio2,

Adding the bin path to the environment variable solved this problem.

Thank you very much.

So what is the purpose of TZConnection.LibraryLocation?

[EgonHugeist]

JanPijnacker,

TZConnection.LibraryLocation is able to load !single! dll's from different path's. So you're able to load a library like libmysql.dll, sqlite3.dll, fbclient.dll with different version and you can simply make an update application from an old server to a new one.

PostgreSQL uses several dll's which the system expects in the default path environment variables. This was the issue you had. All servers which use a single library can handle this except postgresql. I'm sorry but this borders we can't break...

[JanPijnacker]

Hi Egon,

Thank you for this clear explanation.

I'm going to build an application now, just like in the old days with Turbo Pascal:)

-Jan

[rafakwolf]

Hi...

I have the same problem, but already install MS c++ 2010 Redistributable, pg 9.2 and copy dlls for system paths, my application path and still not works...

any other advice ?

thanks.

[EgonHugeist]

rafakwolf,

which compiler? 32Bit or 64Bit? And which system paths do you mean?