Skip site navigation (1) Skip section navigation (2)

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

From: JKorth <jk(at)epos-gmbh(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC Setup Dialog: "Couldn't load libpq - SSL mode is unavailable"
Date: 2009-02-17 14:03:48
Message-ID: 499AC3C4.5090602@epos-gmbh.de (view raw or flat)
Thread:
Lists: 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   



In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2009-02-17 23:50:48
Subject: Re: ODBC Setup Dialog: "Couldn't load libpq - SSL mode is unavailable"
Previous:From: Hiroshi InoueDate: 2009-02-17 03:40:05
Subject: Re: ODBC Setup Dialog: "Couldn't load libpq - SSL mode is unavailable"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group