Re: 08.04.0100: Couldn't load libpq library - Mailing list pgsql-odbc

From Andrus
Subject Re: 08.04.0100: Couldn't load libpq library
Date
Msg-id 44C109BDFD44445BADD871D79D413AD9@andrusnotebook
Whole thread Raw
In response to Re: 08.04.0100: Couldn't load libpq library  (Hiroshi Inoue <inoue@tpf.co.jp>)
List pgsql-odbc
Hiroshi,

> Maybe MSVC2005 redistributable package is needed.
> Please try
>
> http://www.microsoft.com/downloads/details.aspx?familyid=200b2fd9-ae1a-4a14-984d-389c36f85647&displaylang=en

I researched this issue in Windows 98 computer:

1. Installing VS2005 VC++ redistributable from
http://www.microsoft.com/downloads/details.aspx?familyid=200b2fd9-ae1a-4a14-984d-389c36f85647&displaylang=en
does not fix it.
2. Installation of VS2008 VC++ SP1 redistributable does not start: shutdown
installer action complains about missing entry point in WinNT dll
3. Copying manually msvcrt80.dll into odbc and application directories does
not fix it.

I used filemon to trace this issue:

Directory C:\PROGRAM FILES\PSQLODBC\0803\BIN\LIBPQ.DLL SUCCESS QUERY
Open C:\PROGRAM FILES\PSQLODBC\0803\BIN\LIBPQ.DLL SUCCESS OPENEXISTING
READONLY DENYWRITE
Read C:\PROGRAM FILES\PSQLODBC\0803\BIN\LIBPQ.DLL SUCCESS Offset: 0 Length:
64
Seek C:\PROGRAM FILES\PSQLODBC\0803\BIN\LIBPQ.DLL SUCCESS Beginning Offset:
272 / New offset: 272
Read C:\PROGRAM FILES\PSQLODBC\0803\BIN\LIBPQ.DLL SUCCESS Offset: 272
Length: 248
Seek C:\PROGRAM FILES\PSQLODBC\0803\BIN\LIBPQ.DLL SUCCESS Beginning Offset:
272 / New offset: 272
Read C:\PROGRAM FILES\PSQLODBC\0803\BIN\LIBPQ.DLL SUCCESS Offset: 272
Length: 488
Directory C:\PROGRAM FILES\PSQLODBC\0803\BIN\LIBPQ.DLL SUCCESS QUERY
Read C:\PROGRAM FILES\PSQLODBC\0803\BIN\LIBPQ.DLL SUCCESS Offset: 159744
Length: 4096
....
Read C:\PROGRAM FILES\PSQLODBC\0803\BIN\LIBPQ.DLL SUCCESS Offset: 151552
Length: 2048
Attributes C:\PROGRAM FILES\PSQLODBC\0803\BIN\MSVCR80.DLL SUCCESS
GetAttributes
Directory C:\PROGRAM FILES\PSQLODBC\0803\BIN\MSVCR80.DLL SUCCESS QUERY
Open C:\PROGRAM FILES\PSQLODBC\0803\BIN\MSVCR80.DLL SUCCESS OPENEXISTING
READONLY DENYWRITE
Directory C:\PROGRAM FILES\PSQLODBC\0803\BIN\MSVCR80.DLL SUCCESS QUERY
Close C:\PROGRAM FILES\PSQLODBC\0803\BIN\MSVCR80.DLL SUCCESS CLOSE_FINAL
Close C:\WINDOWS\SYSTEM\WLDAP32.DLL SUCCESS CLOSE_FINAL
Close C:\PROGRAM FILES\PSQLODBC\0803\BIN\GSSAPI32.DLL SUCCESS CLOSE_FINAL
Close C:\PROGRAM FILES\PSQLODBC\0803\BIN\K5SPRT32.DLL SUCCESS CLOSE_FINAL
Close C:\PROGRAM FILES\PSQLODBC\0803\BIN\COMERR32.DLL SUCCESS CLOSE_FINAL
Close C:\PROGRAM FILES\PSQLODBC\0803\BIN\KRB5_32.DLL SUCCESS CLOSE_FINAL
Close C:\PROGRAM FILES\PSQLODBC\0803\BIN\LIBICONV2.DLL SUCCESS CLOSE_FINAL
Close C:\PROGRAM FILES\PSQLODBC\0803\BIN\LIBINTL3.DLL SUCCESS CLOSE_FINAL
Close C:\PROGRAM FILES\PSQLODBC\0803\BIN\LIBEAY32.DLL SUCCESS CLOSE_FINAL
Close C:\PROGRAM FILES\PSQLODBC\0803\BIN\SSLEAY32.DLL SUCCESS CLOSE_FINAL
Close C:\PROGRAM FILES\PSQLODBC\0803\BIN\LIBPQ.DLL SUCCESS CLOSE_FINAL
Attributes C:\MYAPPL\ALGUS\LIBPQ.DLL NOTFOUND GetAttributes
Attributes C:\WINDOWS\SYSTEM\LIBPQ.DLL NOTFOUND GetAttributes
Attributes C:\WINDOWS\LIBPQ.DLL NOTFOUND GetAttributes
Attributes C:\WINDOWS\LIBPQ.DLL NOTFOUND GetAttributes
Attributes C:\WINDOWS\COMMAND\LIBPQ.DLL NOTFOUND GetAttributes
Attributes C:\WINDOWS\SYSTEM32\LIBPQ.DLL NOTFOUND GetAttributes
Attributes C:\MYAPPL\ALGUS SUCCESS GetAttributes
Attributes C:\WINDOWS\MEDIA\CHORD.WAV SUCCESS GetAttributes
Open C:\WINDOWS\MEDIA\CHORD.WAV SUCCESS OPENEXISTING READONLY DENYNONE
...

Maybe for some strange reason after initial reading and closing, LIBPQ.DLL
lookup does  not look into 0803\BIN directory.


If SSLMODE=Allow is removed from connection string, it works.

How to use SSL connections is Windows 98 ?

Andrus.


pgsql-odbc by date:

Previous
From: "Andrus"
Date:
Subject: Re: 08.04.0100: Couldn't load libpq library
Next
From: "Sangaran"
Date:
Subject: Reg. Text search.