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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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