psqlODBC - PostgreSQL ODBC driver error

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

psqlODBC - PostgreSQL ODBC driver error

Donovan Hsieh
Hi - I downloaded and installed the 64 bit PostgreSQL ODBC driver from https://odbc.postgresql.org/. However, I got an error while using it from the ER/Studio data modeling tool as shown below.

">

I wonder what could be the reason. It looks like my Windows 10 can't find the DLL even though it's in "C:\Program Files\psqlODBC\1101\bin". Any advise yopu can share will be greatly appreciated.

Regards,
-Donovan

1561562574805blob.jpg (17K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: psqlODBC - PostgreSQL ODBC driver error

Ashutosh Sharma
Hi Donovan,

It seems like the dll(s) on which psqlodbc35w.dll is having dependency is either missing in your system or if it is present then probably it's not being picked from the right place may be because you haven't set the environment variable PATH correctly. I think, in Windows there is a tool named "Dependency Walker" or "depends.exe" which you can use to find the missing dlls.

If I understand correctly, you must have at least the following dlls present in your installation directory.

libpq.dll
krb5_32.dll
libeay32.dll
ssleay32.dll
libintl-2.dll
libiconv-2.dll

-- 
With Regards,
Ashutosh Sharma

On Thu, Jun 27, 2019 at 1:06 PM Donovan Hsieh <[hidden email]> wrote:
Hi - I downloaded and installed the 64 bit PostgreSQL ODBC driver from https://odbc.postgresql.org/. However, I got an error while using it from the ER/Studio data modeling tool as shown below.

Inline image

I wonder what could be the reason. It looks like my Windows 10 can't find the DLL even though it's in "C:\Program Files\psqlODBC\1101\bin". Any advise yopu can share will be greatly appreciated.

Regards,
-Donovan