Re: ODBC Setup Dialog: "Couldn't load libpq - SSL mode is unavailable" - Mailing list pgsql-odbc

Hiroshi Inoue schrieb:
> JKorth wrote:
>> Hello!
>>
>> I tried to set up the "PostgreSQL Unicode" ODBC driver
>> (psqlodbc_08_03_0400 - msi or dll package) under Windows XP.
>> On two computers the ODBC Setup Dialog contains the error message
>> "Couldn't load libpq - SSL mode is unavailable".
>> How do I get SSL to work (=get rid of this message)?
>>
>> What I found out on myself (but didn't help):
>> libpq.dll depends on msvcr80.dll which was missing, but installing
>> the MSVC2008 Redistributable Package didn't made it to work - neither
>> did copying msvcr80.dll into the directory of libpq.dll
>
> Maybe MSVC2005 redistributable package is needed.
> Did you try
> http://www.microsoft.com/downloads/details.aspx?familyid=200b2fd9-ae1a-4a14-984d-389c36f85647&displaylang=en
>
> ?
yesterday I tried the non-SP1 version of the MSVC2005 redistributable
package, but without success.


Today I tried to compare the behavior of a working installation with a
non-working one using Sysinternals Process Monitor.
It doesen't seem that any files are missing; the working installation
continues loading further DLLs after libpq.dll (ssleay32.dll...);
the non-working installation does continue to look for libpq.dll in the
whole search path, but - of course - doesn't find a second version.


WORKING VERSION:
1448    09:44:38,5943131    odbcad32.exe    732    CreateFile
C:\Programme\psqlODBC\0803\bin\libpq.dll.2.Manifest    NAME NOT FOUND
Desired Access: Generic Read/Execute, Disposition: Open, Options:
Synchronous IO Non-Alert, Non-Directory File, Attributes: n/a,
ShareMode: Read, AllocationSize: n/a
1449    09:44:38,5945654    odbcad32.exe    732    CreateFile
C:\Programme\psqlODBC\0803\bin\libpq.dll.2.Config    NAME NOT FOUND
Desired Access: Generic Read/Execute, Disposition: Open, Options:
Synchronous IO Non-Alert, Non-Directory File, Attributes: n/a,
ShareMode: Read, AllocationSize: n/a
1528    09:44:38,6080135    odbcad32.exe    732    ReadFile
C:\Programme\psqlODBC\0803\bin\libpq.dll    SUCCESS    Offset: 147.456,
Length: 8.192, I/O Flags: Non-cached, Paging I/O, Synchronous Paging I/O
1544    09:44:38,6103759    odbcad32.exe    732    QueryOpen
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    CreationTime:
17.03.2008 03:32:00, LastAccessTime: 16.02.2009 15:35:10, LastWriteTime:
17.03.2008 03:32:00, ChangeTime: 12.09.2008 15:26:51, AllocationSize:
196.608, EndOfFile: 196.608, FileAttributes: A
1546    09:44:38,6108190    odbcad32.exe    732    QueryOpen
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    CreationTime:
17.03.2008 03:32:00, LastAccessTime: 16.02.2009 15:35:10, LastWriteTime:
17.03.2008 03:32:00, ChangeTime: 12.09.2008 15:26:51, AllocationSize:
196.608, EndOfFile: 196.608, FileAttributes: A
1551    09:44:38,6112287    odbcad32.exe    732    CreateFile
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    Desired
Access: Execute/Traverse, Synchronize, Disposition: Open, Options:
Synchronous IO Non-Alert, Non-Directory File, Attributes: n/a,
ShareMode: Read, Delete, AllocationSize: n/a, OpenResult: Opened
1554    09:44:38,6115503    odbcad32.exe    732
QueryNetworkOpenInformationFile
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    CreationTime:
17.03.2008 03:32:00, LastAccessTime: 16.02.2009 15:35:10, LastWriteTime:
17.03.2008 03:32:00, ChangeTime: 12.09.2008 15:26:51, AllocationSize:
01.01.1601 01:00:00, EndOfFile: 01.01.1601 01:00:00, FileAttributes: A
1692    09:44:38,6659623    odbcad32.exe    732
QueryStandardInformationFile
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS
AllocationSize: 196.608, EndOfFile: 196.608, NumberOfLinks: 1,
DeletePending: False, Directory: False
1698    09:44:38,6666299    odbcad32.exe    732    CloseFile
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS
1700    09:44:38,6668869    odbcad32.exe    732    Load Image
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    Image Base:
0xd40000, Image Size: 0x30000
1701    09:44:38,6669388    odbcad32.exe    732    ReadFile
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    Offset:
188.416, Length: 8.192, I/O Flags: Non-cached, Paging I/O, Synchronous
Paging I/O
1702    09:44:38,6671662    odbcad32.exe    732    ReadFile
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    Offset: 4.096,
Length: 32.768, I/O Flags: Non-cached, Paging I/O, Synchronous Paging I/O
1703    09:44:38,6772172    odbcad32.exe    732    ReadFile
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    Offset:
36.864, Length: 32.768, I/O Flags: Non-cached, Paging I/O, Synchronous
Paging I/O
1704    09:44:38,6777426    odbcad32.exe    732    ReadFile
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    Offset:
69.632, Length: 32.768, I/O Flags: Non-cached, Paging I/O, Synchronous
Paging I/O
1705    09:44:38,6782696    odbcad32.exe    732    ReadFile
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    Offset:
102.400, Length: 32.768, I/O Flags: Non-cached, Paging I/O, Synchronous
Paging I/O
1706    09:44:38,6788056    odbcad32.exe    732    ReadFile
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    Offset:
135.168, Length: 4.096, I/O Flags: Non-cached, Paging I/O, Synchronous
Paging I/O
1707    09:44:38,6791438    odbcad32.exe    732    ReadFile
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    Offset:
143.360, Length: 16.384, I/O Flags: Non-cached, Paging I/O, Synchronous
Paging I/O
1708    09:44:38,6794209    odbcad32.exe    732    ReadFile
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    Offset:
159.744, Length: 12.288, I/O Flags: Non-cached, Paging I/O, Synchronous
Paging I/O
1709    09:44:38,6803382    odbcad32.exe    732    ReadFile
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    Offset:
172.032, Length: 12.288, I/O Flags: Non-cached, Paging I/O, Synchronous
Paging I/O
1710    09:44:38,6806768    odbcad32.exe    732    ReadFile
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    Offset:
184.320, Length: 4.096, I/O Flags: Non-cached, Paging I/O, Synchronous
Paging I/O
1711    09:44:38,6808329    odbcad32.exe    732    ReadFile
C:\Programme\psqlODBC\0803\bin\ssleay32.dll    SUCCESS    Offset:
139.264, Length: 4.096, I/O Flags: Non-cached, Paging I/O, Synchronous
Paging I/O
1712    09:44:38,6815353    odbcad32.exe    732    QueryOpen
C:\Programme\psqlODBC\0803\bin\libeay32.dll    SUCCESS    CreationTime:
17.03.2008 03:31:58, LastAccessTime: 16.02.2009 15:35:11, LastWriteTime:
17.03.2008 03:31:58, ChangeTime: 12.09.2008 15:26:51, AllocationSize:
1.040.384, EndOfFile: 1.040.384, FileAttributes: A
1714    09:44:38,6822126    odbcad32.exe    732    QueryOpen
C:\Programme\psqlODBC\0803\bin\libeay32.dll    SUCCESS    CreationTime:
17.03.2008 03:31:58, LastAccessTime: 16.02.2009 15:35:11, LastWriteTime:
17.03.2008 03:31:58, ChangeTime: 12.09.2008 15:26:51, AllocationSize:
1.040.384, EndOfFile: 1.040.384, FileAttributes: A
1715    09:44:38,6825885    odbcad32.exe    732    CreateFile
C:\Programme\psqlODBC\0803\bin\libeay32.dll    SUCCESS    Desired
Access: Execute/Traverse, Synchronize, Disposition: Open, Options:
Synchronous IO Non-Alert, Non-Directory File, Attributes: n/a,
ShareMode: Read, Delete, AllocationSize: n/a, OpenResult: Opened
1716    09:44:38,6829047    odbcad32.exe    732
QueryNetworkOpenInformationFile
C:\Programme\psqlODBC\0803\bin\libeay32.dll    SUCCESS    CreationTime:
17.03.2008 03:31:58, LastAccessTime: 16.02.2009 15:35:11, LastWriteTime:
17.03.2008 03:31:58, ChangeTime: 12.09.2008 15:26:51, AllocationSize:
01.01.1601 01:00:00, EndOfFile: 01.01.1601 01:00:00, FileAttributes: A
1738    09:44:38,9006056    odbcad32.exe    732
QueryStandardInformationFile
C:\Programme\psqlODBC\0803\bin\libeay32.dll    SUCCESS
AllocationSize: 1.040.384, EndOfFile: 1.040.384, NumberOfLinks: 1,
DeletePending: False, Directory: False
1744    09:44:38,9013070    odbcad32.exe    732    CloseFile
C:\Programme\psqlODBC\0803\bin\libeay32.dll    SUCCESS
1746    09:44:38,9015629    odbcad32.exe    732    Load Image
C:\Programme\psqlODBC\0803\bin\libeay32.dll    SUCCESS    Image Base:
0xd70000, Image Size: 0x101000
.
.
.
1782    09:44:38,9262454    odbcad32.exe    732    QueryOpen
C:\Programme\psqlODBC\0803\bin\msvcr71.dll    SUCCESS    CreationTime:
01.05.2007 17:01:40, LastAccessTime: 16.02.2009 15:35:11, LastWriteTime:
01.05.2007 17:01:40, ChangeTime: 12.09.2008 15:26:51, AllocationSize:
348.160, EndOfFile: 348.160, FileAttributes: A
.
.
.


NOT WORKING VERSION:
2704    14:33:31,9015964    odbcad32.exe    3816    CreateFile
C:\Programme\psqlODBC\0803\bin\libpq.dll.2.Manifest    NAME NOT FOUND
Desired Access: Generic Read/Execute, Disposition: Open, Options:
Synchronous IO Non-Alert, Non-Directory File, Attributes: n/a,
ShareMode: Read, AllocationSize: n/a
2705    14:33:31,9018439    odbcad32.exe    3816    CreateFile
C:\Programme\psqlODBC\0803\bin\libpq.dll.2.Config    NAME NOT FOUND
Desired Access: Generic Read/Execute, Disposition: Open, Options:
Synchronous IO Non-Alert, Non-Directory File, Attributes: n/a,
ShareMode: Read, AllocationSize: n/a
2811    14:33:32,0508644    odbcad32.exe    3816    ReadFile
C:\Programme\psqlODBC\0803\bin\libpq.dll    SUCCESS    Offset: 147.456,
Length: 8.192, I/O Flags: Non-cached, Paging I/O, Synchronous Paging I/O
2815    14:33:32,0677207    odbcad32.exe    3816    QueryOpen
C:\WINDOWS\system32\libpq.dll    NAME NOT FOUND
2816    14:33:32,0680261    odbcad32.exe    3816    QueryOpen
C:\WINDOWS\system32\libpq.dll    NAME NOT FOUND
2822    14:33:32,0684665    odbcad32.exe    3816    QueryOpen
C:\WINDOWS\system\libpq.dll    NAME NOT FOUND
2823    14:33:32,0687333    odbcad32.exe    3816    QueryOpen
C:\WINDOWS\libpq.dll    NAME NOT FOUND
2824    14:33:32,0689284    odbcad32.exe    3816    QueryOpen
C:\Dokumente und Einstellungen\eduxx_tw\libpq.dll    NAME NOT FOUND
2825    14:33:32,0691472    odbcad32.exe    3816    QueryOpen
C:\WINDOWS\system32\libpq.dll    NAME NOT FOUND
2826    14:33:32,0693168    odbcad32.exe    3816    QueryOpen
C:\WINDOWS\libpq.dll    NAME NOT FOUND
2835    14:33:32,0786454    odbcad32.exe    3816    QueryOpen
C:\WINDOWS\system32\wbem\libpq.dll    NAME NOT FOUND
2836    14:33:32,0787992    odbcad32.exe    3816    QueryOpen
C:\Programme\ATI Technologies\ATI Control Panel\libpq.dll    NAME NOT
FOUND
2838    14:33:32,0790894    odbcad32.exe    3816    QueryOpen
C:\Programme\Gemeinsame Dateien\Ulead Systems\Mpeg\libpq.dll    NAME NOT
FOUND
2840    14:33:32,0793175    odbcad32.exe    3816    QueryOpen
C:\Programme\Gemeinsame Dateien\Roxio Shared\DLLShared\libpq.dll    NAME
NOT FOUND
2842    14:33:32,0797822    odbcad32.exe    3816    QueryOpen
C:\Programme\Sybase\Adaptive Server Anywhere 6.0\win32\libpq.dll    NAME
NOT FOUND
2845    14:33:32,0801972    odbcad32.exe    3816    QueryOpen
C:\Programme\QuickTime\QTSystem\libpq.dll    NAME NOT FOUND
2847    14:33:32,0803509    odbcad32.exe    3816    ReadFile
C:\WINDOWS\system32\gdi32.dll    SUCCESS    Offset: 66.560, Length:
8.192, I/O Flags: Non-cached, Paging I/O, Synchronous Paging I/O
2879    14:33:32,1470895    odbcad32.exe    3816    QueryOpen
C:\WINDOWS\system32\MSIMTF.dll    SUCCESS    CreationTime: 04.08.2004
00:57:28, LastAccessTime: 17.02.2009 14:33:27, LastWriteTime: 04.08.2004
00:57:28, ChangeTime: 29.10.2008 03:27:05, AllocationSize: 159.744,
EndOfFile: 159.232, FileAttributes: A
2880    14:33:32,1473203    odbcad32.exe    3816    CreateFile
C:\WINDOWS\system32\MSIMTF.dll    SUCCESS    Desired Access:
Execute/Traverse, Synchronize, Disposition: Open, Options: Synchronous
IO Non-Alert, Non-Directory File, Attributes: n/a, ShareMode: Read,
Delete, AllocationSize: n/a, OpenResult: Opened
2881    14:33:32,1476195    odbcad32.exe    3816
QueryNetworkOpenInformationFile    C:\WINDOWS\system32\MSIMTF.dll
SUCCESS    CreationTime: 04.08.2004 00:57:28, LastAccessTime: 17.02.2009
14:33:27, LastWriteTime: 04.08.2004 00:57:28, ChangeTime: 29.10.2008
03:27:05, AllocationSize: 01.01.1601 01:00:00, EndOfFile: 01.01.1601
01:00:00, FileAttributes: A
2883    14:33:32,1478094    odbcad32.exe    3816
QueryStandardInformationFile    C:\WINDOWS\system32\MSIMTF.dll
SUCCESS    AllocationSize: 159.744, EndOfFile: 159.232, NumberOfLinks:
1, DeletePending: False, Directory: False
2885    14:33:32,1479776    odbcad32.exe    3816    CloseFile
C:\WINDOWS\system32\MSIMTF.dll    SUCCESS