I have installed the new TDM 4.1.5 and have all the Postgres 9.0 dll copied to the TDM bin directory. At one point, my TDM 4.0 did work before but then get into the same error again before I installed the 4.1.5.
Both TDM bin and Postgres bin and lib are added the PATH on Window7.
But still getting the error:
Connection failed because of the following error: "Error loading library ‘libpq.dll’
Any suggestion is appreciated. Thanks.
Hi,
best would be to try the latest 4.2.1.4 BETA release which has a new connection component and when you use Native Connection, neither libraries nor client is necessary.
For 4.1.5, see Blog (http://blogs.inside.quest.com/modeling/) for libraries required for individual versions of PostgreSQL dbs.
Regards,
Lukas
I am not sure if it is because of the 64-bit windows7
I have the Postgres 9 installed into the Program Files/ not the Program Files (x86)/
But the TDM (v3, v4.0 and now v4.1.5.8) are always installed under the Program Files (x86)/
Besides, I did have the Postgres 8 installed under Program Files (x86)/ which seems to works fine with TDM.
After trying again and again, it finally works.
I checked that both my Postgres 8 and 9 are running 64-bits.
But TDM 4.1.5 only seems to work on Postgres 8. Hence, I copied the following dll from Postgres 8 to the TDM bin directory.
comerr32.dll
gssapi32.dll
k5sprt32.dll
krb5_32.dll
libeay32.dll
liconv-2.dll
libintl-8.dll
libpq.dll
ssleay32.dll
Then I changed the Path back to Postgres 9 and was able to start TDM to connect Postgres 9. Many of the above dll are not able to found in the Postgres 9 bin. Hence, I guess even copy all the dll from Postgres 9 to TDM bin may not work.
Hi,
this issue is fixed since Toad Data Modeler 4.2.1.4 Beta release, which brought a new Native Connection component and no copying of dll libraries is necessary. The component will be also a part of the next Full release.
Regards,
Lukas