Обсуждение: psqlODBC - PostgreSQL ODBC driver error

Поиск
Список
Период
Сортировка

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.

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
Вложения

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 <dhsieh_9@yahoo.com> 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
Вложения